Thread: Copy a range of cells repeatedly
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default Copy a range of cells repeatedly
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?
Reply With QuoteReply With Quote