Lots easier than that...

Sheets("Sheet1").Columns("A").Replace 99, 3, xlWhole
--
HTH...

Jim Thomlinson


"green72" wrote:

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