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

listi.net

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