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

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

If you only want to replace a value with 99 as the only thing in the cell
select the range or columneditreplaceoptionswhole

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

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