Consider EditReplace

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"green72" wrote in message ...
|I would like to scan specific columns (but all the rows in the specified
| columns) for a certain value, in this case 99, and if a cell has a value of
| 99, I need to replace it with another number, 3 in this case.
|
| I think this would be an 'if then' type of thing with a loop perhaps, but
| its been so long since I worked with basic....
|
| Any help would be appreciated.
|
| Thanks