Paste Special Macro
Hi,
I was hoping that someone could tell me how to create a macro that I can link to a customized button on my toolbar that simply does a "edit" "paste special" "values". I have to use this function quite a bit throughout my day and just wanted a shortcut. Thanks for your help. Aaron |
Paste Special Macro
Aaron,
Excel has a button that does this, but it isn't shown by default. Right click on a commandbar, choose customize, then choose the "Commands" tab, "Edit" category, and then drag the "Paste Values" button from the commands window to the commandbar where you want it to appear. I have mine to the right of the regualr paste. HTH, Bernie MS Excel MVP "Aaron" wrote in message ... Hi, I was hoping that someone could tell me how to create a macro that I can link to a customized button on my toolbar that simply does a "edit" "paste special" "values". I have to use this function quite a bit throughout my day and just wanted a shortcut. Thanks for your help. Aaron |
Paste Special Macro
I use the following macro, and I've attached a shortcut key to it,
CTRL+SHIFT+V. It requires only that you select the cells to be converted (must be a single-area selection); it does *both* the copying and the pasting. Sub ConvertToValues() With Application .ScreenUpdating = False .DisplayAlerts = False End With With Selection .Copy .PasteSpecial Paste:=xlValues End With With Application .CutCopyMode = False .DisplayAlerts = True End With End Sub 'ConvertToValues On Wed, 11 Aug 2004 08:32:13 -0700, "Aaron" wrote: Hi, I was hoping that someone could tell me how to create a macro that I can link to a customized button on my toolbar that simply does a "edit" "paste special" "values". I have to use this function quite a bit throughout my day and just wanted a shortcut. Thanks for your help. Aaron |
Paste Special Macro
Myrna,
Why not just? Sub ConvertToValues() Selection.Value = Selection.Value End Sub Bernie "Myrna Larson" wrote in message ... I use the following macro, and I've attached a shortcut key to it, CTRL+SHIFT+V. It requires only that you select the cells to be converted (must be a single-area selection); it does *both* the copying and the pasting. Sub ConvertToValues() With Application .ScreenUpdating = False .DisplayAlerts = False End With With Selection .Copy .PasteSpecial Paste:=xlValues End With With Application .CutCopyMode = False .DisplayAlerts = True End With End Sub 'ConvertToValues On Wed, 11 Aug 2004 08:32:13 -0700, "Aaron" wrote: Hi, I was hoping that someone could tell me how to create a macro that I can link to a customized button on my toolbar that simply does a "edit" "paste special" "values". I have to use this function quite a bit throughout my day and just wanted a shortcut. Thanks for your help. Aaron |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com