Which version of Excel?

For 2002 and newer you can select from the Options to look in "Workbook"

Older versions you had to first select all the sheets into a
group" then editreplace.

Note: in Excel 97 editfind did not work with grouped sheets but editreplace
did.......strange but a fact.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 11:51:01 -0800, J@Y wrote:

Can I use the Replace function to go through all the worksheets in a workbook?