find replace
 

I am looking for a macro that will find and replace text in the formulas
contained within a group of cells (B2:B65).
The text that I want to find is contained in a cell (T3) and the text that I
want to insert is contained in a cell (T4).
Any suggestions of a macro or builtin function that I am unaware of?
Thanks,
Micah

find replace
 

Sub Replace()
Range("B2:B65").Replace What:=Range("T3"), _
Replacement:=Range("T4"), LookAt:=xlwhole
End Sub
--
Charles Chickering

"A good example is twice the value of good advice."


"Micah" wrote:

I am looking for a macro that will find and replace text in the formulas
contained within a group of cells (B2:B65).
The text that I want to find is contained in a cell (T3) and the text that I
want to insert is contained in a cell (T4).
Any suggestions of a macro or builtin function that I am unaware of?
Thanks,
Micah

find replace
 

Thanks for the help. That works like a champ.

Micah

"Charles Chickering" wrote:

Sub Replace()
Range("B2:B65").Replace What:=Range("T3"), _
Replacement:=Range("T4"), LookAt:=xlwhole
End Sub
--
Charles Chickering

"A good example is twice the value of good advice."


"Micah" wrote:

I am looking for a macro that will find and replace text in the formulas
contained within a group of cells (B2:B65).
The text that I want to find is contained in a cell (T3) and the text that I
want to insert is contained in a cell (T4).
Any suggestions of a macro or builtin function that I am unaware of?
Thanks,
Micah