Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate a range a specified number of times
Sub ABC()
Dim rng As Range, dest As Range Dim i As Long Set rng = Range("A2:B5") Set dest = Range("A7") For i = 1 To Range("A1").Value rng.Copy dest Set dest = dest.Offset(0, rng.Columns.Count) Next End Sub -- Regards, Tom Ogilvy "Tbone" wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate a range a specified number of times
The code would look something like this:
Dim i As Integer, copyRange As Range Set copyRange = Range("A2:B5") For i = 1 To Range("A1") copyRange.Copy copyRange.Offset(0, i * copyRange.Columns.Count).PasteSpecial Next i On May 4, 3:26 pm, Tbone wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the number of times a word is used in a range of cells | Excel Worksheet Functions | |||
Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
Duplicate rows a given number of times in Excel? | Excel Programming | |||
Duplicate entry "x" number of times | Excel Discussion (Misc queries) | |||
how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) |