Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet copy speed
Hi,
I workshet with 60 VBA controls on it and 786 lines of vba code behind those controls. Where possible the code uses functions and sub routines to save repetition. The problem I have is that when I try and copy the sheet it takes about 30 seconds to copy the single sheet!!!! Is their anything I can do to speed it up? I have stripped the vba code of all indents, spaces, and comments. thanks Lewis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet copy speed
"Lewis Brunton" wrote in message
... Hi, I workshet with 60 VBA controls on it and 786 lines of vba code behind those controls. Where possible the code uses functions and sub routines to save repetition. The problem I have is that when I try and copy the sheet it takes about 30 seconds to copy the single sheet!!!! Is their anything I can do to speed it up? I have stripped the vba code of all indents, spaces, and comments. Can you post an example of the code that you think is too slow? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet copy speed
"Damien McBain" wrote:
Can you post an example of the code that you think is too slow? Well thats the problem you see, its not the code that is too slow. Just copying the worksheet takes the time, whether I do it manually or with a macro. I have found that deleting the files in the temp folder has speeded up the copy process, but it it still not as fast as when the worksheet had no macros attached to it. thanks Lewis Brunton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct against worksheet vs named range- any speed difference? | Excel Worksheet Functions | |||
Worksheet speed with array formula | Excel Discussion (Misc queries) | |||
Speed up calculation of a worksheet that contains formula | Excel Worksheet Functions | |||
Loss of Speed During Copy Operation | Excel Programming | |||
raw speed for excel worksheet functions? - xll -or com addin? | Excel Programming |