Give this a try...

Sub DoStuff()
Dim wks As Worksheet

For Each wks In Worksheets
wks.Cells.Replace "\=", "="
Next wks
End Sub

--
HTH...

Jim Thomlinson


"psoftguy" wrote:

Hi,
Here's what I need to do: select all sheets in a workbook and do a
replace of "\=" with "=" on each of these sheets. I can do it manually,
but I have no exposure to VBA and am having troubles coding it. To do
it manually- right click on the name of the worksheet - a menu will pop
up. Click on "Select Al Sheets". Now, when you select "Find" or
"Replace" from the Edit menu in Excel, all worksheets in your workbook
will be searched.

Any help would be really appreciated!!!

Thanks!