Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a for/next loop such as this...
On Error Resume Next i = 5 For col = 1 To 7 Step 2 AppPerWS.Range(Cells(30, col), Cells(54, col)).Copy AppendWS.Range("A" & i).PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, _ SkipBlanks:=False, _ Transpose:=True Application.CutCopyMode = False i = i + 1 Next col The problem is that an compile error pops up that says "variable not defined" I didn't think you had to define these...do you? Any clue?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Define Variable Name using VBA | Excel Discussion (Misc queries) | |||
Define a Variable | Excel Programming | |||
define variable range | Excel Programming | |||
Using a Variable to Define Series | Charts and Charting in Excel | |||
How to define variable | Excel Programming |