Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Having an odd problem with the Range.Copy method.
This code: Set source= Range("VL_Source") Set target = VL.Offset(1).Resize(1, 1) source.Copy Destination:=target works fine. However the same thing with positional parameter: Set source= Range("VL_Source") Set target = VL.Offset(1).Resize(1, 1) source.Copy (target) fails with the error- Run-time error '1004': Copy methid of Raneg class failed As far as I can see they mean exactly the same thing (source and target are both declared as type Range). Any idea why this happens? Regards; Colin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range.Copy [Destination] should not use clipboard | Excel Discussion (Misc queries) | |||
How do I prevent copy and pasting into a selected range of a works | Excel Discussion (Misc queries) | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Range.Copy (Destination) | Excel Programming | |||
Problem with named range as VBA macro parameter | Excel Programming |