By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 290 - Paste

The Paste Method is part of the Clipboard activities.

You can use Excel and Cut/Copy and Paste while using the Macro Recorder to show the various code that's generated.

The most common statement you get is

ActiveSheet.Paste

Exercise

Record a Paste Special to Convert to Values

Create a Sub called PasteSpecial

Use the Sub

Solution