Macro to search for a word and copy the row containing it to another worksheet

Hi,

I'm trying to write a code that will search the row for the word "Novartis". If the row contains the word - it will be the first column that will contain it - the whole row will be copied to another worksheet.

The first worksheet (one where we are searching for the word) is called "Consolidation" and the second worksheet is called "Novartis" - this is the worksheet we are copying the row to.

Here is my code:

Please Login or Register  to view this content.

Whenever I try to run the macro, I come up with an error telling me Error 424 The object is not defined, with the row of code starting with erow highlighted, or an error saying Can't execute code in break mode.

Can anybody see what is wrong with my code?

You may need to define x as a variable. Add this to the beginning:

Please Login or Register  to view this content.

Another way:

Please Login or Register  to view this content.

Originally Posted by alansidman

Try the following:

Please Login or Register  to view this content.

I had just written a solution when I saw this post, so I posted it too, although I am sure this does the trick

So true alansidman! I think it can be really exciting to see how other VBA writers (often more experienced then me) attempts to solve the very same problem, their valued inputs and unique style.

FANTASTIC, they both worked, thank you so much!!