Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What type of loop?
I am trying to create a loop for the following statement
Set r1 = Range(Cells(4(i), 3), Cells(4(i), 4)) Set r2 = Range(r1, Cells(4(i), 5)) r2.Copy Cells(5(i+1), 2).PasteSpecial Transpose:=True the i and i+1 are the values that I want to be changing. My loop needs to be changing in increments of 4. I have a feeling that I have to do somekind of loop that would allow me to do the following for i=1 inew=i+4 i new = i and the loop continues but when I tried this or anything close to the for i=1 would take control more than the inew part. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop type formula - no Macro | Excel Discussion (Misc queries) | |||
For Each Loop skip using user-defined type? | Excel Programming | |||
DoWhile Loop & Type mismatch error | Excel Programming | |||
Loop through a User-Defined Type? | Excel Programming | |||
Type Error in For Each Worksheet Loop | Excel Programming |