View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tbone tbone is offline
external usenet poster
 
Posts: 8
Default duplicate a range a specified number of times

How can I copy a range of cells and duplicate it the number of times
specified in a specific cell?

For example cell A1 has 3 as the value. I want to copy A2:B5, and duplicate
it three times (the number in cell A1) and paste side by side in the same
sheet say beginning in cell A7. If cell A1 had a 7 as the value, I want to
copy and duplicate the range 7 times etc.

Thanks!