extract a range into VB from another workbook

[luv2glyd]

Trying to load a range into VB from another workbook, but getting an error:

Please Login or Register  to view this content.

Thanks

[TMS]

If ABCDE is meant to be a text string, it's not, it's an undefined variable and hence it is empty/null. Put it in double quotes ... "ABCDE".

[luv2glyd]

Ooops.... In the original code it is a string. My mistake, sorry. I just forgot to put it in quotes here.

I got it to work finally, but with a rather long line. Is this the only way that this can be done using "Cells(...." Seems like there should be a shorter method. Trying to avoid using Range("A3:T62") format where I have to refer to columns by letters instead of numbers.

Please Login or Register  to view this content.

[TMS]

Maybe this (untested):

Please Login or Register  to view this content.

[luv2glyd]

Ok, that will work quite a bit better. Thanks!

PS: for anyone looking at this in the future - did some testing and realize I can just do this:

Please Login or Register  to view this content.

[TMS]

Not quite sure why I wrote it like that . Using "With" means I can write:

Please Login or Register  to view this content.

And thanks for the rep