Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I let a macro repeat itself in excel
1 2 3 4 5 6 7
8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 I want to have the figures above in 1 vertical column. I can do it by Transpose them line by line, but is there a macro to automate this process thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I let a macro repeat itself in excel
Sub AAA()
Dim i As Long, j As Long, k As Long Dim v(1 To 42, 1 To 1) k = 0 For j = 1 To 6 For i = 1 To 7 k = k + 1 v(k, 1) = Cells(j, i) Next Next Range("I1").Resize(42, 1) = v End Sub -- Regards, Tom Ogilvy "Spil" wrote in message ... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 I want to have the figures above in 1 vertical column. I can do it by Transpose them line by line, but is there a macro to automate this process thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat a Macro | Excel Worksheet Functions | |||
Repeat Macro | Excel Worksheet Functions | |||
How to program an excel macro to repeat a series of keystrokes? | Excel Discussion (Misc queries) | |||
How do I set up a macro to repeat automatically in Excel? | Excel Programming | |||
How do I get an Excel Macro to repeat automatically? | Excel Programming |