![]() |
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? |
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