Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Range gives object defined run wrror
I am trying to copy a range from one sheet to another using the following statement. I do not get a compile error but a Object Defined Run Error. I am calling this from the current worksheet with a command button and putting the data in a sheet called "Sample Log" What am I doing wrong? Worksheets("Sample Log").Range(Cells(samplerow, 6), Cells(samplerow, 42)).Value = Range(Cells(R, 6), Cells(R, 42)).Value |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR | Excel Programming | |||
Application-defined or object-defined error (worksheet, range, sel | Excel Programming | |||
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
Range - Application Defined or Object Defined Error | Excel Programming |