search xl file w/vba
Never mind, I misread you posting.
--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote:
Did you try going to File=Open, then in the upper right of the dialog,
select tools and then Search?
--
Regards,
Tom Ogilvy
"inov8r" wrote:
i am looking to enter a search term, look in the entire workbook for the
term, then return the sheet name and row number of all found instances. wild
card searches would be a bonus if possible. tried a few things but nothing
works quite right.
|