In fields a1 and a2 I have two aplhanumeric values , call them "d0409" and
"d1309".
I simply need to use these values (although they change each week) as input to a replace but within a macro. For example
Find :- d2808
Replace with :- d0409 (Value of Cell a1).
I was given the following code but it doesnt seem to work :-
Selection.Replace What:="rrr", Replacement:="=a1", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
Remember , the a1 and A2 values are not constants.Can this be done ? Thanks , I'm sure this question will take some of you no time at all ! I'm a new user.
"d1309".
I simply need to use these values (although they change each week) as input to a replace but within a macro. For example
Find :- d2808
Replace with :- d0409 (Value of Cell a1).
I was given the following code but it doesnt seem to work :-
Selection.Replace What:="rrr", Replacement:="=a1", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
Remember , the a1 and A2 values are not constants.Can this be done ? Thanks , I'm sure this question will take some of you no time at all ! I'm a new user.