Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help!!! Code problem 1004
I am trying to run the following macro and it dies when
it reaches "Range("A(i):C(j)").Select". What am I doing wrong? Please help. TIA 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error code 1004 | Excel Worksheet Functions | |||
JB Bates' Runtime Error 1004 problem | Excel Discussion (Misc queries) | |||
Error Code 1004 when exporting from VB app to Excel 2007 | Excel Discussion (Misc queries) | |||
I got this problem run-time error 1004 application defined ... | Excel Discussion (Misc queries) | |||
Coding problem: Runtime 1004 | Excel Programming |