Use variable to find and copy range with find function

So, I have the following piece of code that is searching a specific word and it should copy the range starting in the cell under it until last row. It returns an error on the line marked in red. I hope that someone may have an idea why and how to change it.

Please Login or Register  to view this content.

Thanks

Change the line in red to:

Please Login or Register  to view this content.

Hi, Olly, many thanks, works like a charm. If I am not asking too muck, do you mind telling me the difference between them?

Your variable "cell" refers to a range object. You were trying to refer to it as a string.
(incidentally, that's a very bad variable name, it's not a good idea to use reserved words as variables)

We fixed this by defining the range with two range objects:

Please Login or Register  to view this content.

You could also fix it by referring to the range address, which is what you were trying to do initially, in which case the code would change to:

Please Login or Register  to view this content.

I'd also recommend qualifying the first Range object in your Set cell line, and changing the ActiveCell reference to a static range...