Worksheet copy speed

[Guest]

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

 

[Damien McBain]

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?

 

[Guest]

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