Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-20-2012, 12:32 AM
paulkaye paulkaye is offline Paste-As-Text macro Windows 7 64bit Paste-As-Text macro Office 2007
Advanced Beginner
Paste-As-Text macro
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default Paste-As-Text macro

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
Reply With Quote
 

Tags
macro, paste, text



Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste-As-Text macro Paste text box onto graph, text disappears sarasbluegroove Word 6 12-20-2016 07:22 AM
Paste-As-Text macro 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-As-Text macro Paste Special Unformatted Text kenwpaul Office 2 02-25-2011 04:53 PM
Paste-As-Text macro 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft