Thread: [Solved] paste special default
View Single Post
 
Old 03-18-2011, 11:54 AM
Ulodesk Ulodesk is offline Windows 7 32bit Office 2007
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 866
Ulodesk is on a distinguished road
Default 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
Reply With Quote