Why can't i copy from an opened workbook without an error??

[dbravo]

Hello,

I am having a problem trying to copy ranges in a specific sheet in an open workbook to the main workbook without activating each sheet individually?

THIS WORKS

Please Login or Register  to view this content.

But this does NOT

Please Login or Register  to view this content.

Why can i not directly copy a range without having to activate each sheet?

[Norie]

You can, but you need worksheet references for each instance of Range and Cells.

Please Login or Register  to view this content.