ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cut Paste Undo Failed (https://www.excelbanter.com/excel-programming/287487-cut-paste-undo-failed.html)

Von Shean

Cut Paste Undo Failed
 
I have a cut paste problem in Excel. This is related to undoing paste in
certain excel worksheet region.
Excel produces two change events, one for a cut and one for paste.
I fill data related to every user action in another sheet in the same
workbook. So for every cut event is log a cut event and paste i log an
update event. Problem comes in cut paste on a region where i want to undo
all changes. when i get the paste event i have already made changes to the
log sheet and Undo fails to operate.

It there any solution or workaround for this issue?



J.E. McGimpsey

Cut Paste Undo Failed
 
The solution is to write an undo routine for your code. See

Undoing a VBA Subroutine
http://j-walk.com/ss/excel/tips/tip23.htm

In article ,
"Von Shean" wrote:

I have a cut paste problem in Excel. This is related to undoing paste in
certain excel worksheet region.
Excel produces two change events, one for a cut and one for paste.
I fill data related to every user action in another sheet in the same
workbook. So for every cut event is log a cut event and paste i log an
update event. Problem comes in cut paste on a region where i want to undo
all changes. when i get the paste event i have already made changes to the
log sheet and Undo fails to operate.

It there any solution or workaround for this issue?



All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com