Need a macro for Paste

  • 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:

    Code
    Sub Cut()
    Selection.Cut
    End Sub
    
    
    Sub Copy()
    Selection.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.


    Thanks,
    AX

  • 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

Participate now!

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