Dan Murphy’s Blogs

You have to grow up - But you can be immature your whole life

 

Must Have Microsoft Office Macro

Posted by: Dan | Posted in: Codeing/Development

image A little while ago I created a macro that does a paste special, paste plain text.  This comes in very handy when copying and pasting and you don’t want to carry over formatting.  After creating the macro I added a shortcut to it as CTRL-SHIFT-V.  So when I want to paste without formatting this saves me a ton of time.  Below is the code you need to put into the macro.

Sub PlaintextPaste()

Selection.PasteSpecial Link:=False, DataType:=wdPasteText, Placement:= _
wdInLine, DisplayAsIcon:=False
End Sub

Leave a Reply