Find/Replace Question

Let's start with this.

Please Login or Register  to view this content.

I would start with something small that you know works and build from there. Make sure when you post code, enclose it in code blocks b/c I'm not sure if I'm allowed to respond... depends on the forum (but they all have code blocks people prefer to use).

Below, I didn't pay much attention to the Replace Method's arguments, but I restructured the code to loop through the entire column B.

Please Login or Register  to view this content.

...no debugging has been done to the above code.

Note: Re-Edited about 10 min after original post to execute your replacement method if the row in column B contains (rather than =) the string stored in cat.

Counter is just a variable that holds the rownumber and it increments with 1 on every loop.

Please Login or Register  to view this content.

at first loop counter starts at 2
cells(counter,2) = range("B2")
cells(counter,4) = range("D2")

next loop counter is 3
cells(counter,2) = range("B3")
cells(counter,4) = range("D3")

and so one....until all filled cells in column B are passed.

No need to use end if if all statements are on 1 codeline.
Could also be written as

Please Login or Register  to view this content.

PS: Thanks for rep+.