Delete all rows in table containing value from cell in another sheet

  • Hi,
    I'm trying to adapt some code I have copied to fit my needs. I want to delete all rows in a table which are equal to or less than a cell value in another sheet. The table will become larger over time. Obviously I am incompetent at vba so any help is much appreciated!


    At the moment I have a 'compile error: Sub or function not defined' for the text 'worksheet'' in this line 'nm = Worksheet("SystemNames").Range("L2")'


  • Re: Delete all rows in table containing value from cell in another sheet


    I can't stop laughing( at myself ) . So simple, I can't see the wood for the trees, thanks dangelor, that works fine now.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!