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