Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in a Search and Replace macro
I have a formula in many worksheets that needs to be modified.
I have a macro that goes to each worksheet but I would like to use a variable in the text to be replaced so I dont have to update the macro for each sheet. I would like to something like; FOR X= 1 TO 80 Selection.Replace What:="min1", Replacement:="min27", etc etc.... NEXT X Where the replacement string becomes Replacement:="minX" and increments for each x Is this possible? thanks sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Search and Replace | Excel Discussion (Misc queries) | |||
macro to search and replace with offset | Excel Discussion (Misc queries) | |||
Macro to Search and Replace | Excel Programming | |||
SEARCH & REPLACE MACRO | Excel Programming | |||
Macro search replace question | Excel Programming |