Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 493
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to undo paste in Excel Manimal Excel Discussion (Misc queries) 1 July 3rd 08 01:40 PM
Paste Method of Worksheet Failed When Copying Chart Object Larry[_3_] Excel Discussion (Misc queries) 0 May 17th 07 11:02 PM
Paste Special Macro - can't undo Ben New Users to Excel 2 May 10th 07 03:44 AM
Method 'Paste' of object '_Worksheet' failed markline Excel Discussion (Misc queries) 7 May 28th 05 05:02 AM
Paste method of worksheet class failed error Todd Huttenstine[_2_] Excel Programming 1 December 16th 03 10:08 AM


All times are GMT +1. The time now is 06:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"