MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to use the Edit Find to search a workbook with multiple worksheets.


Posted by Kurt on August 14, 2000 4:26 PM

Hello everybody.

Does anybody have a macro that will search across multiple worksheets in a single workbook. If you use the Ctrl+F to find a word, etc. it will only search in that one worksheet that you are currently on. Does anybody know of a way to do this?

Thanks again in advance,

Kurt Nichols


Posted by Kurt on August 17, 0100 3:19 PM

Thanks Celia that was fast!

Posted by Celia on August 14, 0100 4:42 PM

Kurt

Dim ws As Worksheet
For Each ws In Worksheets
ws.Activate
'PUT YOUR CODE HERE
Next ws

Celia