Delete entire row based if value not in named range.

  • Hello everyone:


    I want be able to delete all rows in Sheet1 inf the names in column A do not match the names in the named range nameList. I have worked out the following code, by I can't get it to work. I keep getting Runtime error 1004.



    I can't figure out what I am doing wrong here.


    I also posted on http://www.mrexcel.com/forum/e…l-basic-applications.html

  • Re: Delete entire row based if value not in named range.


    Hi jmazorra


    Does nameList exist?
    Your reference to 'rng' doesn't look correct?


    You might be better doing this with a filter. Can you post a small sample workbook please?

Participate now!

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