Prev: Searching based on text
Next: separate text and number
From: Michael on 10 Apr 2010 01:55
Perhaps an addition would be the ability to assign meaning to an open hot
key, example ctrl-alt-shift-v might mean past values in Excel.

The ctrl-alt-v does indeed bring up the past special dialog box in excel
2007 and is quite useful.

From: p45cal on 10 Apr 2010 06:53

Michael;695668 Wrote:
>
Perhaps an addition would be the ability to assign meaning to an open
hot
> key, example ctrl-alt-shift-v might mean past values in Excel.
>
> The ctrl-alt-v does indeed bring up the past special dialog box in
excel
> 2007 and is quite useful.



Easier for one hand:
Alt+e, then s,v,Enter

Apart from that, you can; create this macro:



VBA Code:
--------------------



Sub Macro5()
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub


--------------------



then in the- Macros|View Macros- dialogue box, select it, click options
and assign it the hot key combination you want. Works here.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=194555

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Searching based on text
Next: separate text and number