Reading out Variant Array to an inactive worksheet

Can't get this to work if I use Cell keyword rather than Range.

Please Login or Register  to view this content.

The code is executed whilst another worksheet is active (not the EventHistory one).


There's a problem with the line .Range(Cells(2, 1)) = arrVariant(1, i). If I try using the alternative cell reference notation:

Please Login or Register  to view this content.

This works but I need to start changing the row,col refs for Cell so can't use the "A2" notation. I've tried moving the . around to before/after the Range keyword, before after the Cell keyword etc but I always get:

Run-time error '1004': Application-defined or object-defined error.

Any ideas?

Cheers
-Rob

Hi,

Just use cells() syntax like this :

Please Login or Register  to view this content.

-------------
Edit :
According to your case, if you want to fill A2:Axxx with arrVariant, it could be something like this :

Please Login or Register  to view this content.

Regards

You are welcome.

Regards