using match function

[phillypdh]

i have a sub that searches for specific text in a range of cells however i can only get it to react to the first occurence .

lCountay = Application.Match("*TEXAS*", Range("D1:D165"), 0)
MsgBox "Found 'TEXAS' at row : " & lCountay

is there a way ot include all occurences of "TEXAS" ?

 

[Scott Huish]

Instead of using worksheet functions, have a look in the VBA help file for the Find and FindNext method.

 

[phillypdh]

thanks for your time I'm headed in the right direction.