Short-cut for Paste Values
 

Hi,

Does anyone know the short-cut for Paste Values option in Excel?

Thanks in advance,
Irada


--
Irada Shamilova
------------------------------------------------------------------------
Irada Shamilova's Profile: http://www.excelforum.com/member.php...o&userid=12286
View this thread: http://www.excelforum.com/showthread...hreadid=383089

Hi
I'd like to know that too! I reckon it'll need a macro writing, and then
assigning it to a shortcut key.
At the moment I've customised my toolbar to have a Paste Special button on
it - you could do that in the meantime!

--
Andy.


"Irada Shamilova"
<Irada.Shamilova.1rdzyd_1120046733.4233@excelfor um-nospam.com wrote in
message news:Irada.Shamilova.1rdzyd_1120046733.4233@excelf orum-nospam.com...

Hi,

Does anyone know the short-cut for Paste Values option in Excel?

Thanks in advance,
Irada


--
Irada Shamilova
------------------------------------------------------------------------
Irada Shamilova's Profile:
http://www.excelforum.com/member.php...o&userid=12286
View this thread: http://www.excelforum.com/showthread...hreadid=383089

I do have that icon on my toolbar, but still like to use shortcuts where
possible - speeds up the process!


--
Irada Shamilova
------------------------------------------------------------------------
Irada Shamilova's Profile: http://www.excelforum.com/member.php...o&userid=12286
View this thread: http://www.excelforum.com/showthread...hreadid=383089

Is it ok if the Edit|Undo is lost -- this happens a lot when macros are run?

If yes, then this worked ok for me:

Option Explicit
Sub PasteSpecialValues()

Dim myCtrl As CommandBarControl
Set myCtrl = Application.CommandBars.FindControl(ID:=370)

On Error Resume Next
myCtrl.Execute
If Err.Number < 0 Then
Beep
Err.Clear
End If

End Sub


Tools|macro|macros|options button
give it a nice shortcut (ctrl-shift-V??)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Irada Shamilova wrote:

I do have that icon on my toolbar, but still like to use shortcuts where
possible - speeds up the process!

--
Irada Shamilova
------------------------------------------------------------------------
Irada Shamilova's Profile: http://www.excelforum.com/member.php...o&userid=12286
View this thread: http://www.excelforum.com/showthread...hreadid=383089

--

Dave Peterson

Note that with MacXL, you can use the Tools/Customize/Keyboard dialog to
assign nearly any keyboard shortcut to any XL command.

That would be a nice feature to port to WinXL.

In article
<Irada.Shamilova.1re8au_1120057529.5044@excelfor um-nospam.com,
Irada Shamilova
<Irada.Shamilova.1re8au_1120057529.5044@excelfor um-nospam.com wrote:

I do have that icon on my toolbar, but still like to use shortcuts where
possible - speeds up the process!

I came to the forum looking for a solution to this shortcut problem as
well, and I see that there are three principal suggestions:

1. Macro
2. A series of keystrokes
3. Add button to toolbar

I wanted to add to #3, that once you add the "Paste Values" button to
your toolbar, it's possible to turn it into a two-key keyboard
shortcut. Just open up the Tools-Customize Menu, right-click on your
newly placed "Paste Values" button, and fiddle with the ampersand (&)
in the "Name" field. If you set it up to a letter that isn't already in
use (for me, it's "A"), then voila! You now have a keyboard shortcut
using the ALT-key plus that letter.

Hope this helps someone out there.


--
dfg
------------------------------------------------------------------------
dfg's Profile: http://www.excelforum.com/member.php...o&userid=10750
View this thread: http://www.excelforum.com/showthread...hreadid=383089