Copying and pasting to and from an array

[vbacoder]

Hi everyone,

I have written a macro to copy and past multiple selections from one worksheet to another. The code is rather messy, and it runs slow. To help speed things up, I want to know if there is some way in which all the copy operations could be done in one go, and stored sequentually in an array, and then retrieved concurrently in one set of pasting operations. So rather than copy > paste > copy > paste ... I want array(copy) > array(paste).

Many thanks,

vcoder

 

[vbacoder]

I think I didn't explain this very well.

I want to copy several separate sections on a worksheet and place these sequentially in an array, then paste these in order in another worksheet.

At the moment, the macro has to straddle between two worksheets several times, carrying out multiple alternate copy and paste operations as only one section can be copied at any one time.

Thanks,

vcoder