I am not sure you can do this without the worksheet being used. You can
assign an unused cell the value of 2, do your pastespecial multiply, then
clearcontents on the cell with the temporary 2 in it.

Range("Q1").Value = 2
Range("Q1").Copy
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply, _
SkipBlanks:=False, Transpose:=False
Range("Q1").ClearContents

Mike F

"JMay" wrote in message
...
I've currently using the following

Range("Q1").Copy 'my cell Q1 contains the Value 2
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply, _
SkipBlanks:=False, Transpose:=False

But I would like to include the VAlue 2 in this code (away from
Spredsheet)

I'de like to use a normal Variable like
MyMult = 2 ' I obviously need to get MyMult into the CLIPBOARD, but
How??

How would I change the above code to accomidate the MyMult