Replace data using a macro in Excel 2000

[tglancy]

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).

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.

 

[leibale]

without a macro:
use edit find. in the replace box, write: =a1
change all
you may wish to convert the formulas to values. do it by copy the range and paste special, values
thanks

 

[tglancy]

Thanks , but it really has to run as a macro. Silly , but thats the way it is !

 

[leibale]

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