VBA for find and replace based on cell value

[kim_mandy36]

Hi I don't have that much experience with VBA programming and I usually just use recorded macros. Unfortunately I don't know how to solve this problem of mine. Can you guys help me out?

Let's say I have a table with the ff data

A B C
1 2 2
2 2 2
1 2 2
2 2 2

Now on D1 I type the number 1 and on D2 I type the number 2. What I want the VBA to do is to search column A for all values that was placed on D1 (in this case the number 1) and replace them with what is placed on D2 (in this case the number 2). I don't want to touch the values on column B&C just the one on column A. Can this be done?

Thanks

[Leith Ross]

Hello kim_mandy36,

1. Copy the code below to the clipboard using Ctrl+C.
2. Right click the worksheet tab where the data is.
3. Select View Code from the context menu.
4. Paste the code using Ctrl+V.
5. Save the changes using Ctrl+S

Please Login or Register  to view this content.

[kim_mandy36]

I tried this but it wouldn't run. Does it take in to account the value to be searched in cell D1? What I plan to do with this macro is assign it to a button. I enter the data I want searched on the first column in D1, enter the data I want to replace it with in D2, then click the button to run the macro which will search for the D1 value in column one and replace them with the D2 value

[kim_mandy36]

Sorry I don't know if I can do this but I need to bump this up again

[kim_mandy36]

Can I bump this up again?

[kim_mandy36]

I finally found the answer on this site (credit goes to Tom Ogilvy)

http://en.allexperts.com/q/Excel-105...lace-VBA-1.htm

Please Login or Register  to view this content.