Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.Copy (Destination)
Hi
Can someone please explain where I'm going wrong with this simple two line chunk of code? B7 is the currently selected cell on the active sheet. I've assigned the cell reference for D10 to a variable named copycell by using the following line: Let copycell = Selection.Offset(3,2).Address(False,False) All I want to be able to do is copy the contents of D10 (an = sum() formula) to E10 using the Range.Copy ([Destination]) method but if I use Range (copycell).Copy (Range(copycell).Offset (0,1)) it returns Run Time Error 1004 (Copy method of Range class failed). However, if I use a range object offset from the current cell (B7) as the destination i.e. Range (copycell).Copy (Selection.Offset (3,3)) it pastes the relative formula from D10 into E10 as required. What am I doing wrong? Thanks for any suggestions. Garry Douglas ** Please Remove SPMOFF To Reply ** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range.Copy [Destination] should not use clipboard | Excel Discussion (Misc queries) | |||
Using copy and destination formatting | Excel Discussion (Misc queries) | |||
VBA .copy destination | Excel Discussion (Misc queries) | |||
.Copy Destination:= .PasteSpecial ??? | Excel Programming | |||
Selection.Copy Destination:= | Excel Programming |