Assistance with code

J

JMay

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
 
M

Mike Fogleman

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
 
J

JLGWhiz

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.
 
Top