View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rob c rob c is offline
external usenet poster
 
Posts: 5
Default Run-time error €˜1004

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