Short Cut for Paste Special 1

[Matsul]

Is there a way to map Pate Special --> values to say Ctl-W.

I made a macro and mapped that to ctl-p but if I need to undo it does not work so wondered is there is a simpler way.

 

[GlennUK]

Paste Special what? Values? Formats? Comments?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Matsul]

Values.

regards,

Matt

 

[GlennUK]

I have the Paste Special Values toolbar button on my Standard Toolbar next to the Format Painter. ( to get this button on your toolbar, right-click any toolbar, choose Customize/Commands category Edit, and drag the button from the Command list to where yuo'd like it to be )

Alternatively use the menu short-cut keystrokes Alt-E-S-V-Enter.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

I have that but I also have the following code in my Personal.xls file:

Sub pastespec()
Selection.PasteSpecial Paste:=xlValues
End Sub

I don't use the shortcut for 'Undo' so I have assigned the keystroke Ctrl+Z to the the shortcut for the macro. Works well as I can do CTRL+C, CTRL+Z to do a copy then paste special values - very quick.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question