Find and Replace (Ctrl-H) will do that, so just do it with the macro
recorder switched on.

--
__________________________________
HTH

Bob

"bijan" wrote in message
...
Hi All,
I have a sheet like this:
A B C
1 2B2 1 NRC
2 2B2 2 WW
3 2C2 1 BLK
4 2C2 2 BLK
5 2C2 3 BLK
How can I find 2C2 with value 3 in column B (row 5) and change BLK in
column
C
with whatever I want?