T
tkt_tang
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.
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.