Thanks

Batu

Gord Dibben wrote:
Select all cells with formulas in sheet "Y"

EditReplace

What: =

With: ZZZ

Replace all.

Delete sheet "X"

Insert new sheet named "X"

Reverse the editreplace.

Gord Dibben MS Excel MVP

Suppose I have an excel workbook with two sheets X and Y.

[quoted text clipped - 15 lines]

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200911/1