faster than VBA macros
 

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