PAStE SPECIAL

[Guest]

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]

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.

 

[Guest]

thank you very much, you gave me many options thanks again.

 

[JMay]

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

 

[dgp]

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

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