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

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?

O, I guess i have an old version of excel. Thanks.

"Gord Dibben" wrote:

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?

Don't guess at your version.

Click HelpAbout to see your version edition and release number.


Gord

On Tue, 23 Jan 2007 12:23:04 -0800, J@Y wrote:

O, I guess i have an old version of excel. Thanks.

"Gord Dibben" wrote:

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?

Hi J@Y

try this it is useful for u and easy also !

Go to find and replace option ( shortcut Ctrl+H)
u will get the Find :__________ and Replace :_________
there is small button options .
click the options .......... there is blank heading within................
in that black space u just click work book.......

what u want to replace entire work book will change

try this i hope it is useful for u

steps : ctrl+H ,,,,,,, find,,,,,, replace ,,,,,,
options,,,,,,,,within,,,,,worksheet

it will work


waiting for reply
--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



"Gord Dibben" wrote:

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?