Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba copy code
this code is in sheet1; and the last line, before end sub,
produces an "application defined or object defined error". can someone tell me why? Sub x10() Dim COUNTER1 As Integer Dim COUNTER2 As Integer COUNTER1 = [A1] COUNTER2 = [B1] Range(Cells(COUNTER1, 1), Cells(COUNTER1, 71)).Copy _ Worksheets("SHEET2").Range(Cells(COUNTER2, 1)) End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba copy code
Sub x10()
Dim COUNTER1 As Integer Dim COUNTER2 As Integer COUNTER1 = [A1] COUNTER2 = [B1] Range(Cells(COUNTER1, 1), Cells(COUNTER1, 71)).Copy _ Worksheets("SHEET2").Cells(COUNTER2, 1) End Sub -- Regards, Tom Ogilvy "Paul" wrote in message ... this code is in sheet1; and the last line, before end sub, produces an "application defined or object defined error". can someone tell me why? Sub x10() Dim COUNTER1 As Integer Dim COUNTER2 As Integer COUNTER1 = [A1] COUNTER2 = [B1] Range(Cells(COUNTER1, 1), Cells(COUNTER1, 71)).Copy _ Worksheets("SHEET2").Range(Cells(COUNTER2, 1)) End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and use vba code | New Users to Excel | |||
copy and use vba code | Excel Discussion (Misc queries) | |||
Help with COPY code | Excel Discussion (Misc queries) | |||
Copy Code | Excel Programming | |||
Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming |