MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Search multiple worksheets


Posted by Tim Johnson on February 08, 2002 8:59 AM

Can you perform a search or search & replace over multiple worksheets in a file? I tried to select more than one sheet, then do a search, but that only seemed to search the active worksheet.


Posted by Jennifer on February 08, 2002 10:30 AM

Hi - when I select all worksheets and run the "find" command, it does go through all of them and not just the active one.

Posted by Chris D on February 08, 2002 12:33 PM

Select your sheets *then* highlight your range, it will do it in all sheets.....