accelerator for paste special in excel 2000

  • Thread starter Thread starter vishwa
  • Start date Start date
Hi
one way:
- create/record a macro for paste special
- assign a shortcut to this macro (in the macro dialog)
 
Frank Kabel said:
Hi
one way:
- create/record a macro for paste special
- assign a shortcut to this macro (in the macro dialog)
Click to expand...

I did just that some time ago but, altho' I did do an unformatted
paste while recording the macro, I had to edit it to get an
unformatted paste. For the record, the operative and only (apart from
the usual subroutine delimiters) line in the macro should be:-

Selection.PasteAndFormat wdFormatPlainText
 
Back
Top