View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default Re - GGVT Excel Copy of a WorkSheet Takes Mighty Long Time

Re - GGVT Excel Copy of a WorkSheet Takes Mighty Long Time

An Excel WorkSheet1 contains two event-handlers namely,
1. SelectionChange
2. BeforeRightClick

When WorkSheet1 is copied en masse (selected by clicking the
top-left-corner thereof) to another WorkSheet2, it takes a really
mighty long time to complete the task.

The question is, what is holding up the copy-and-paste operations ?

Is there a way to circumvent the lengthy duration of the process ?

As a comparison, a regular WorkSheet3 (reasonable sized but minus the
event-handlers) could be copied (sheet-to-sheet) rather rapidly.
Please share your comment on the above delineation.

Regards.