Rob C,

It is probably in the variable FOUND_LIST. When you click on debug the
following and the line is highlighter hover over the FOUND_LIST with your
mouse. Probably it is returning EMPTY.

If this is the case you have to set the variable somewhere. For example:
FOUND_LIST = "A1", however this is depending on what you code should do and
which range have to be set in your code.


brotha lee
"rob c" wrote:

I copied some bode from a book that takes up about 3 pages that isn't working.

I get the following error message:

"Run-time error €˜1004;
Method €˜Range of object €˜_Worksheet failed"



When I click on debug the following line is highlighted:

"Set rgTopLeft = ws.Range(FOUND_LIST).Offset(1, 0)"

Any suggestions on how I can find out what needs to be changed in order to
make this work?

Regards,

Rob