Thank you very much for your assistance!
With one minor adjustment I was able to have it do exactly as intended. I'm re-sending you the final revised code and have one task left!
The workbook is attached - The remaining thing that I can't get to work is "Undo the paste of an entire row when the row is selected via the row number"
The paste itself works with the minor change I made to your code.
I think the change needs to be made here somewhere:
1) Click on "Row 21" to select entire row (A:XFD)
2) CTRL+C to copy
3) Click on "Row 22" to select entire row (A:XFD)
4) CTRL+V to paste (shortcut assigned to macro)
Only_PasteValue_Or_Text
5) Attempt undo using native button - Fails
I can't work out what needs to change in the undo module as I've shared above
To clarify, the values highlighted in red is not an error, it's simply part of where my troubleshooting landed me as being a reason why I can't get what I need to work.
I appreciate the time you've put in to help me
Bookmarks