#1
|
|||
|
|||
paste special default
I've tried to build a macro for paste-special-unformatted. It works as expected when I'm recording the macro, but when I run the macro later, it pastes-formatted. When I view the macro, it says that formatted is the paste special default, so I'm guessing I need to change the default to get the macro to function the way I want. Any suggestions? |
#2
|
|||
|
|||
Unformatted
Hi, Croy. Word's recorder simply won't do it; I don't know enough to know why. In any case, the one below works; it's what I use daily.
If you're unfamiliar with the VBA editor, press Alt+F11 to open it. Double-click on the New Macros module in the Macros module on the left, and find the macro you named and recorded in the right-hand text pane. If will begin with Sub and the name you gave, and end with End Sub. Replace that with this, or edit it to match this. Best, Ulodesk Sub PasteUnformatted() ' ' PasteUnformatted Macro ' Selection.PasteSpecial Link:=False, DataType:=wdPasteText End Sub |
#3
|
||||
|
||||
My preference is for:
Code:
Sub PasteUnformattedText() ' The next line is in case there's nothing in the Clipboard On Error Resume Next Selection.PasteSpecial DataType:=wdPasteText End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Paste Special Unformatted Text | kenwpaul | Office | 2 | 02-25-2011 04:53 PM |
Paste Special Link no longer working | MrsMoe | PowerPoint | 0 | 12-20-2010 10:54 PM |
special copy/paste | iconofsin | Excel | 1 | 09-15-2010 12:10 AM |
Using Paste/Special wih Excel data | chickasaw | PowerPoint | 0 | 02-05-2010 10:00 PM |
Copy and paste special | Dace | Excel | 2 | 02-16-2009 12:18 PM |