Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAStE SPECIAL
hello,
can i creat a macro for only pate value (like=paste special value) at the moment i have to go paste special way again and again, it would be in activete cells (i means i want paste in selected cells) thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAStE SPECIAL
Saved from a previous post:
You can get to via Tools|customize|Commands Tab|Edit category Drag the "Paste Values" icon to your favorite toolbar (or create new customized toolbar). Other people have created macros that they assign to shortcut keys (and load with their personal.xl* file so it's always available). Something like: Option Explicit Sub MyPasteSpecialValues() If Application.CutCopyMode = False Then Beep Else ActiveCell.PasteSpecial Paste:=xlPasteValues End If End Sub The assign it a nice shortcut key (Ctrl-Shift-V??). Tools|Macro|Macros Select the macro Click Options type in your shortcut key (case is important) Ok out of that dialog Cancel out of this one. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ============ You may find that modifying your favorite toolbar is safer--if you run a macro, you'll notice that the Edit|Undo stack is cleared. And sometimes Edit|undo is a nice safety net. Tufail wrote: hello, can i creat a macro for only pate value (like=paste special value) at the moment i have to go paste special way again and again, it would be in activete cells (i means i want paste in selected cells) thanks in advance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAStE SPECIAL
thank you very much, you gave me many options thanks again.
"Dave Peterson" wrote: Saved from a previous post: You can get to via Tools|customize|Commands Tab|Edit category Drag the "Paste Values" icon to your favorite toolbar (or create new customized toolbar). Other people have created macros that they assign to shortcut keys (and load with their personal.xl* file so it's always available). Something like: Option Explicit Sub MyPasteSpecialValues() If Application.CutCopyMode = False Then Beep Else ActiveCell.PasteSpecial Paste:=xlPasteValues End If End Sub The assign it a nice shortcut key (Ctrl-Shift-V??). Tools|Macro|Macros Select the macro Click Options type in your shortcut key (case is important) Ok out of that dialog Cancel out of this one. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ============ You may find that modifying your favorite toolbar is safer--if you run a macro, you'll notice that the Edit|Undo stack is cleared. And sometimes Edit|undo is a nice safety net. Tufail wrote: hello, can i creat a macro for only pate value (like=paste special value) at the moment i have to go paste special way again and again, it would be in activete cells (i means i want paste in selected cells) thanks in advance. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAStE SPECIAL
FWIW..
Adding: Application.CutCopyMode = False just above the "End Sub" line would get rid of the annoyingly active "circling-ants" visual.. (thereby emptying the Clip Board) Jim May " wrote in message : Saved from a previous post: You can get to via Tools|customize|Commands Tab|Edit category Drag the "Paste Values" icon to your favorite toolbar (or create new customized toolbar). Other people have created macros that they assign to shortcut keys (and load with their personal.xl* file so it's always available). Something like: Option Explicit Sub MyPasteSpecialValues() If Application.CutCopyMode = False Then Beep Else ActiveCell.PasteSpecial Paste:=xlPasteValues End If End Sub The assign it a nice shortcut key (Ctrl-Shift-V??). Tools|Macro|Macros Select the macro Click Options type in your shortcut key (case is important) Ok out of that dialog Cancel out of this one. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ============ You may find that modifying your favorite toolbar is safer--if you run a macro, you'll notice that the Edit|Undo stack is cleared. And sometimes Edit|undo is a nice safety net. Tufail wrote: hello, can i creat a macro for only pate value (like=paste special value) at the moment i have to go paste special way again and again, it would be in activete cells (i means i want paste in selected cells) thanks in advance. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAStE SPECIAL
On Feb 24, 10:17 am, "JMay" wrote:
FWIW.. Adding: Application.CutCopyMode = False just above the "End Sub" line would get rid of the annoyingly active "circling-ants" visual.. (thereby emptying the Clip Board) Jim May " wrote in message : Saved from a previous post: You can get to via Tools|customize|Commands Tab|Edit category Drag the "Paste Values" icon to your favorite toolbar (or create new customized toolbar). Other people have created macros that they assign to shortcut keys (and load with their personal.xl* file so it's always available). Something like: Option Explicit Sub MyPasteSpecialValues() If Application.CutCopyMode = False Then Beep Else ActiveCell.PasteSpecial Paste:=xlPasteValues End If End Sub The assign it a nice shortcut key (Ctrl-Shift-V??). Tools|Macro|Macros Select the macro Click Options type in your shortcut key (case is important) Ok out of that dialog Cancel out of this one. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ============ You may find that modifying your favorite toolbar is safer--if you run a macro, you'll notice that the Edit|Undo stack is cleared. And sometimes Edit|undo is a nice safety net. Tufail wrote: hello, can i creat a macro for only pate value (like=paste special value) at the moment i have to go paste special way again and again, it would be in activete cells (i means i want paste in selected cells) thanks in advance. -- Dave Peterson I wrote a macro to do the same thing and assigned Ctrl+Shft+V as the shortcut. The only problem is that when you paste special with a macro there is not an easy way to undo. I never went to the trouble to create an undo macro and have been screwed several time when I tried to Paste (Ctrl+V) and accidently hit the shift key and ended up pasting values over something and not being able to undo. Since then I just memorized Alt,E,S,V menu keyboard shortcut - this allows you to undo. You can also replace the 'V' to perform other paste special commands: f = Formulas, t = Formats, m = Multiply. Dave Parker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Cut and Paste using Macro gives paste special method error | Excel Programming | |||
How do I capture user paste action and convert to Paste Special | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |