Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set CopyRange Error
I have another post but did not want to add more confusion with just
one line that I'm trying to resolve and understand. This line is giving me an error when I try to execute: Set CopyRange = _ .Range("C" & c.Row & ":H" & c.Row) CopyRange.Copy Destination:=Sheets("Sheet2").Range("C" & RowCount) I googled it and found the following: Row Set CopyRange = Range("C1:C" & LastRowC) CopyRange.Copy Destination:=Range("D" & NewRowD) Is it the "_" underscore and "." period after the equal sign causing the line to error? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |