I'm going cray with this paste proc - please help, i'm new to this
Posted by Jason on September 15, 2000 2:03 AM
I need to copy a range of cells from one worksheet and then paste.special them into another.
I keep getting a debug error when the destination cells are selected. I've marked the erroneous code with **
Here is the code -
Private Sub CommandButton2_Click()
Selection.PasteSpecial Paste:=xlValues, Operation:=xlSubtract, SkipBlanks _
Application.CutCopyMode = False
Any help would be greatly appreciated.
Thanks in advance.