Copy a range of cells repeatedly

[Exceller]

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?

 

[Duke Carey]

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

 

[RagDyer]

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".