In this example, the range A1:B4 contains raw numbers and the range D1:E4 squares those numbers using a formula. He tries to paste the contents of your clipboard two different ways. Mitch does a very clever thing with this macro. Grab them below and you’ll be writing powerful macros in no time. That’s why we created our free VBA Developer Kit and our Big Book of Excel VBA Macros to supplement this tutorial. Make powerful macros with our free VBA Developer Kit PasteSpecial Format : = 'Text', Link : = False, DisplayAsIcon : = False End Sub PasteSpecial Paste : = xlPasteValues, _ Operation : = xlNone, SkipBlanks : = False, Transpose : = False '// Paste as unformatted text ActiveSheet. ' Tip: assign this to a keyboard shortcut: Ctrl+Shift+V ' Developer: Mitch '= Sub PasteValues () '// first test if pasting from within excel, if an error then ' proceed to paste as unformatted text On Error Resume Next '// Paste as values Selection. '= ' # Paste as values or unformatted text from within or outside of Excel. VBA Paste Values or Unformatted Text Created by Mitch Just look for “Community Submissions” in the Auto-Import dropdown menu. wellsrPRO users can automatically import this community submission, along with any other macro posted on, directly into their spreadsheet.

If you’re an existing wellsrPRO member, don’t forget to submit your own macro to the wellsrPRO community using the Share My Macros button. Reader’s Note: This article is part of a series featuring macros submitted by my incredible wellsrPRO community members. I can’t believe I didn’t think of it! I want you all to extend a big thank you to wellsrPRO power user, Mitch, for submitting this macro to me via the wellsrPRO add-in. This is one of the best tips I’ve seen in quite a while. The macro is smart enough to paste unformatted text, too.

You can bind this VBA macro to the Ctrl+Shift+V keyboard shortcut to make pasting even faster. In this tutorial, I’ll show you how to use VBA to paste values in Excel instead of formulas.

Keyboard shortcut for paste values