Delete rows that do not contain keywords in multiple columns

Greetings,

I have this code that I found on the internet that will delete all rows that do not contain certain keywords in column C and move all the remaining rows up while retaining my Header row.

Please Login or Register  to view this content.

I'm working on a different project now and need to do essentially the same thing but the keywords are in different columns. I'm looking for "TIMESTAMP" in column C or "86563VLTM_2016_0F" in column D and keep only the rows that meet that criteria. Obviously, if I modify the code I have and run it twice (once for each keyword) the first one I run will delete the rows with the second keyword.

I've tried changing the range (shown below) but I get an "Invalid use of Property" error.

Please Login or Register  to view this content.

I've also tried modifying these

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

with no luck.

Obviously I'm a novice at this!

Any help would be greatly appreciated. Thanks in advance.

Try this...

Please Login or Register  to view this content.

My bad. Try this...

Please Login or Register  to view this content.

Originally Posted by PKW57

Sweet!

Thank you very much for your time!

You're welcome. Thanks for the feedback.