Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assistance with code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assistance with code
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assistance with code
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need assistance with code, please | Excel Programming | |||
Code assistance | Excel Programming | |||
Assistance with code Please | Excel Discussion (Misc queries) | |||
Code assistance please | Excel Programming | |||
VBA Code Assistance | Excel Programming |