Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste special macro
How can it be the "active"cell if you have copied the new range?
-- Don Guillett Microsoft MVP Excel SalesAid Software "jack" wrote in message ... How do I change the first three lines of the macro below so that the paste special statement will execute to the active cell of a separate worksheet after making the manual copy selection ? Sub Macro3() Range("B6:H6").Select Selection.Copy Range("L6").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut & Paste Need Special Macro | Excel Discussion (Misc queries) | |||
Cut and Paste using Macro gives paste special method error | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Macro/Paste Special | Excel Programming | |||
Macro to Paste Special | Excel Programming |