View Single Post
  #29  
Old 11-12-2008, 07:29 PM
GatesIsAntichrist's Avatar
GatesIsAntichrist GatesIsAntichrist is offline
Member
SOA AAA
 
Join Date: Mar 2005
Location: Hell (on temporary assignment on Earth)
Favorite beer: New(fave)! Black'n'Tan
Posts: 206
Default

It's not petty. I also know no shorter than alt-esv{enter}. My approach was to put this in personal.xls and gave it control-shift-V
Code:
Sub PasteValues() ' Control-Shift-V
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub
Reply With Quote
 
Page generated in 0.17361 seconds with 9 queries