Searching spreadsheet from within VBA

[phudgens]

Does anyone know of a way to search an Excel spreadsheet (V 2003) from within a VBA script and have it keep track of what it finds as well as the file and cell in which the string was found? I know that the cells.find method can be used to search for a string, but I'm not seeing a way for VBA to then keep track of what it finds.

Thanks,
Paul Hudgens
Denver

 

[osx99]

This link may be of use

http://www.cpearson.com/excel/RangeFind.htm