Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This may be kind of basic, and this may not be your problem, but I struggled
with speed with my first macros until I discovered that one should switch off application.screenupdating, and calculation (look them up in the help files). Remember to switch them on again at the end of the routine.... Lloyd Rubidge "Rimcon" wrote in message ... I use a lot of VBA macros in excel (2003). One of them runs 50,000 Monte Carlo simulations and it takes 3-4 hours to run on a 3 gigaHz machine. I've seen demos where 100,000 scenarios run in less than 1 minute. I think I need to learn a faster language to implement my macros. Any recommendations? C++, C#, something else? -- GP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can this be done faster? | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
faster than VBA macros | Excel Programming | |||
faster than VBA macros | Excel Programming | |||
Which one is faster? | Excel Programming |