Find and Replace Macro Based on Cell Reference and Inputbox

[bwaite87]

Good morning,

I simply want to run a macro that will FIND based on the cell value of cell A1
And REPLACE with whatever I type into my input box.

The range is all in "Sheet1" and runs from about A1:N500

Can anyone help me?

[HaHoBe]

Hi, bwaite87,

have you tried recording a macro with Find/Replace?

Please Login or Register  to view this content.

Ciao,
Holger

[Yraen]

Try this:

Please Login or Register  to view this content.

Guess I type to slow lol

[bwaite87]

Thank you both. Both worked perfectly!