If you use the variable to store the value 2, then you do not need to copy
anything to use that value anywhere on the worksheet. i.e. you can use code
like:

ActiveSheet.Range("b10") = myMult

or you and use:

ActiveSheet.Range("B10") = Sheets(2).Range("A6")*myMult

The clipboard is not essential for using the value stored in the variable.

"JMay" wrote:

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