Paste-As-Text macro

paulkaye · #1 11-20-2012, 12:32 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste text box onto graph, text disappears	sarasbluegroove	Word	6	12-20-2016 07:22 AM
A macro that can insert FILENAME, sendkeys CTRL ALT T, paste clipboard, and nextline	kyjac85	Word VBA	13	09-20-2012 05:00 PM
Paste Special Unformatted Text	kenwpaul	Office	2	02-25-2011 04:53 PM
Macro to paste unformatted text	Andacar	Word	2	01-05-2011 09:15 PM
How to create macro to paste text after style?	Srivas	Word	0	03-16-2010 05:28 AM