If I copy and paste cells within any given spreadsheet i can undo it by using
the undo button. But if I assign the same copy/paste routine to a command
button I don't get the chance to use the undo function.

How do I fix this? I have a series of command buttons that perform a wide
range of common tasks and procedures but I don't get the chance to undo them
if i click the wrong button by accident.

Ummm.... Help? Maybe?

Thanks in advance,
Rob