Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Find

Posted by ilias liangas on October 28, 2001 8:23 PM

I was wondering if you can search all sheets in one workbook with one command

Re: Find

Posted by Juan Pablo on October 29, 2001 6:18 AM

Sure, just select all the sheets (Right click on any sheet tab and then select 'Select all sheets'), now goto edit - Find, and it'll look in all of your sheets.

Juan Pablo

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.