Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing values on multiple sheets using a macro
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing cell reference on multiple sheets in one go.... | Excel Worksheet Functions | |||
Help needed replacing multiple cells from a list of values. | Excel Discussion (Misc queries) | |||
Lookup multiple values on multiple sheets | Excel Programming | |||
Filtering and replacing values through a macro | Excel Worksheet Functions | |||
Replacing (identical) values in multiple workbooks simultaneously? | Excel Programming |