View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
 
Posts: 267
Default Help with copying range btw workbooks (advanced example)

Hi Bernie -

Yes, of course, the De-Bug button .... never used that one before
(seriously) ...

It errors on your modified code from above:
Trange = Cells(5, Tcol).Resize(496, 1).Address
Run-Time Error 1004: Application-defined or Object-Defined Error

I also noticed that in the Watch Window, all variables (getstore,
Tcol) are OK, but then when Trange errors out, they all say 'Out of
Context'. Not sure if that helps point in some direction, but figured
it might help...

ideas?

//ray