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 |
Paste special macro
What I am referring to is after manually copying a series of cells in one
spreadsheet, using paste special macro to paste the copied info to any "active" cell in another spreadsheet. I am thinking that I need to replace the 1st three lines of the recorded macro to do this. "Don Guillett" wrote in message ... 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 |
All times are GMT +1. The time now is 03:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com