TIMOTHY wrote:

we all know when we're working in excel normally by using ctrl+z we
can go to the last step. While using VBA i found we can't go back to
the last step,
whats your suggestion?
Always create a backup file?

Save before you run your macro. If you don't like the results, close without
saving and re-open.

--
You left me incomplete, all alone as the memories still remain.