Need a macro for Paste

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hello everyone,
    I always think it's going to be easy this time, but then I hit a snag.
    I have created buttons on the ribbon for cut, copy and paste. I know that they already exist, but my clients need everything on one custom tab.
    The macros for Cut and Copy are:

    Sub Cut()
    End Sub
    Sub Copy()
    End Sub

    Simple and they work great. But the same process does not work for a PASTE button. Can anyone help me with code for this? Of course, it will be used after pressing the Cut or Copy button.


  • Re: Need a macro for Paste

    I think you need to specify a place to paste.

    For instance,

    sheets("sheet1").range("A1").paste xlpastevalues

    After copying, will paste in sheet 1 under cell reference A1, pasting as values

  • Re: Need a macro for Paste


    but my clients need everything on one custom tab

    Then you are going to need a Ribbon Editor - a simple "Ribbon Editor Excel" search will find some good examples, and free.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!