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
|