Replacing data in a cell

[green72]

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

 

[Niek Otten]

Consider Edit>Replace

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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

 

[Don Guillett]

If you only want to replace a value with 99 as the only thing in the cell
select the range or column>edit>replace>options>whole

 

[Jim Thomlinson]

Lots easier than that...

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