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

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

Tom Ogilvy

Comment out the event handlers and try doing the copy. does it make a
difference?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Copy Range of cells with a condition to another worksheet 3
Re : Excel Creation of a New Copy and the Duplication of Names thereof 1
Copy a range of information to a worksheet in a specific file 1
Excel cut and paste row takes a long time. Lots of formulas. 1
HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004 1
Run time error (Copy Method of Worksheet class failed) 5
Copy a Sheet to an AddIn 2
Excel Help takes a very long time to load 4

Top