I am trying to copying a range of cells eg. 10 rows/1 column down repeatedly
on the same spreadsheet about 50 times. Is there a macro I can use to caopy
the rows without having to copy and paste 50 times manually?

Copy it once - select ALL 40 of the destination cells - then paste


"Exceller" wrote:

I am trying to copying a range of cells eg. 10 rows/1 column down repeatedly
on the same spreadsheet about 50 times. Is there a macro I can use to caopy
the rows without having to copy and paste 50 times manually?

Select all the 10 cells.
*Right* click on the fill handle of that 10 cell selection and drag down to
Row 500.

When you release the mouse, from the dialog box choose "Copy Cells".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Exceller" wrote in message
...
I am trying to copying a range of cells eg. 10 rows/1 column down
repeatedly
on the same spreadsheet about 50 times. Is there a macro I can use to
caopy
the rows without having to copy and paste 50 times manually?