I regularly need to copy and paste-as-text (rather than pasting formatting/html, etc.). In MS Word, I use the following macro:
Code:
Sub PasteSpecial()
Selection.PasteSpecial DataType:=wdPasteText
End Sub
but I get a runtime error when I try to use this in Excel. I assume there's something fundamentally different that I don't understand between the programs. At the moment I use ctrl+alt+v to bring up the paste special dialogue box, but I'd like to be able to just ctrl+shift+v to paste as plain text.
Any advice would be most appreciated.
Paul