Easy Question - Copy Array To A Single Column

[Genus Max]

Hi, I cant figure out how to copy an array to a single column, ie., c56 to c70. It copies to a row fine.

Thanks.,

Please Login or Register  to view this content.

[Andy Pope]

Try this

Please Login or Register  to view this content.

[Genus Max]

Fantastic thanks!

[Genus Max]

Hi, how do I get it to copy multiple columns? ie copy c6:d30 to a cell starting at c56?

Thanks!

[Genus Max]

Code I'm using

Please Login or Register  to view this content.

[rorya]

Resize the output columns too:

Please Login or Register  to view this content.