Copy paste array from one worksheet to another

[Xenthys]

Hi!

I am trying to do a very basic thing on VBA but getting bugs after bugs.

I want to copy paste the values only from an array from one worksheet to another but am struggling with the syntax. My code is as follows but I am getting a bug "Object doesn't support Property or Method" on the row with the Paste function

Please Login or Register  to view this content.

Thank you in advance,

Xenthys

[Xenthys]

My bad, you have to select the first cell of the target array and then paste: it seems to work with the code below

Please Login or Register  to view this content.

[Olly]

You could simplify to:

Please Login or Register  to view this content.

[Xenthys]

Yes, indeed, much more elegant

Thank you