View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shineofleo shineofleo is offline
external usenet poster
 
Posts: 2
Default How to speed up VBA program in Excel?

Hi Everyone,

I wrote a Macro in VBA that calculate something, and there are three
loops in it. In short, it runs terribly slow... which is obvious...
because the program displays all the change of certain values on screen
during the processing...

My question is how to speed up it? How to put the computing behind
screen just like C programm... such as 'compile first then run' style?

I really need some help because I was a C/C++/VC programmer other than
VBA programmer... any idea would be welcomed.

Thank you in advance!



Leon