copy and paste multiple selection

Tech-Archive recommends: Speed Up your PC by fixing your registry

Have had a look in Help but not able to find an answer to my problem, in
fact Help says that what I want is not possible so I thought I would turn to
the pro's.

I want to copy a selection of cells and paste them into a row on another
***.

An example would be to copy:

Sheets("Sheet1").Range("T5,C7:T9,T13,C15:T17,T19,C21:T23")

and put it into A4:F4 on Sheet2

I know I can do it one cell at a time but I was hoping that I could speed
things up and do it all in one go as the macro will be quite long.

Thanks in advance.

Gareth


.

Quantcast