Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to undo paste in Excel | Excel Discussion (Misc queries) | |||
Paste Method of Worksheet Failed When Copying Chart Object | Excel Discussion (Misc queries) | |||
Paste Special Macro - can't undo | New Users to Excel | |||
Method 'Paste' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
Paste method of worksheet class failed error | Excel Programming |