Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need for speed!
So I have been working on this big excel project. It was slow b/c it did cell by cell reference. I really speeded it up by changing all that to use arrays
My only issues now is that when you double click on the excel icon for the project to open it, it takes like 30 seconds to load...dude!!!!!Can I speed this up and how. Is there something in VBA I can do to make it not load up all that stuff it is loading up that may not be needed Thank you very muc Neil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need for speed!
Hi
how large is your file and are you running some macros on start-up? -- Regards Frank Kabel Frankfurt, Germany Neil wrote: So I have been working on this big excel project. It was slow b/c it did cell by cell reference. I really speeded it up by changing all that to use arrays. My only issues now is that when you double click on the excel icon for the project to open it, it takes like 30 seconds to load...dude!!!!!Can I speed this up and how. Is there something in VBA I can do to make it not load up all that stuff it is loading up that may not be needed? Thank you very much Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speed issues | Excel Worksheet Functions | |||
VBA Speed up | Excel Discussion (Misc queries) | |||
Can you speed UP drag speed? | Excel Discussion (Misc queries) | |||
I need mor Speed!!!! | Excel Discussion (Misc queries) | |||
Speed? | Excel Programming |