Issue with the copy of an array with dynamic rows

[rjnc]

Hi All,

I think this is a relatively easy fix, im having troubles with the following code.

Please Login or Register  to view this content.

My issue is instead of just column A, i need to copy A:L, however i cant seem to get it to work.

Any assistance would be a great help!

Thanks!

[MickG]

Perhaps:-

Please Login or Register  to view this content.

[rjnc]

Perhaps:-

Please Login or Register  to view this content.

Thanks for the quick reply MickG, i have added your code, however it is still only pasting Column A, not the desired A:L

[rjnc]

Perhaps:-

Please Login or Register  to view this content.

Thanks MickG, it worked apologies i had an additional piece of code that was overwriting yours. Much appreciated!

[MickG]

You're welcome