View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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.