Excel VBA Find String in Cells

Josh Hazel
05-07-2010, 11:32 PM
Is there a better method than a loop to run through a column of cells and checking if it contains a specific string? It just feels sloppy and though maybe there is some built in function of checking for a string in a range of cells

Bob Phillips
05-08-2010, 07:22 AM
Of course, the Find/FindNext functions. Look it up in VBA help, there is a good example there.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum