Hi Lazer,

I need to iterate through all the cells of a worksheet and delete all
rows that contain any words in a specific list. This "keyword" list is
quite long. What's the best way to store these words - keeping in mind
both ease of adding more and ease of iteration, as well?

I would use a Dictionary object from the Windows scripting runtime for
the keyword list, mainly because it has an Exists property to test if an
item is in the list.

However, it might be more efficient to iterate through the list and use
Range.Find to see if they're used, rather than iterate through the cells
to see if they're in the list. It'll probably depend on the relative
size of the sheet and the lists.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk