Creating a shortcut
Hi,
1.. Create a macro like that: Sub MyPasteSpecial() Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub 2.. Go to Tools Macro Macros. 3.. In Options assign a shortcut. -- JP http://www.solutionsvba.com "jeff" wrote in message ... I would like to know if it is possible to create a shortcut for the Paste special option. Example. CUT= ctrl+X Copy= ctrl+c Paste= ctrl+V I would like to know how to create a shortcut for the Paste special. Does any one know how to do this?? Any info would help. Thanks |
All times are GMT +1. The time now is 12:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com