Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP!! Range selection doesn't work
I am running the following macro and it returns a Range
Selection Global error when it gets to "Range("A(i):C (j)").Select". What am i doing wrong? Pingger Dim i As Integer, j As Integer, k As Integer i = i + 1 j = j + 1 k = k + 1 j = j + 21 Do While j < 1100 Range("A(i):C(j)").Select Selection.Copy Range("F(k)").Select Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:=False _ , Transpose:=True i = j + 1 j = i + 21 k = k + 3 Loop End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does the Selection not work | Excel Discussion (Misc queries) | |||
How to make View Fit Selection work? | Excel Discussion (Misc queries) | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
How do I keep the selection box in the work area | Excel Discussion (Misc queries) |