are sums in code quicker than formulars

[justme1122]

Hi guys

I just have 2 general questiosn to try and speed up some sheets that I run:

-Will a formular written in VBA process a lot quicker than in a cell in excel?

-Is is posible to turn off screen updating vir a macro and leave it off untill a second macro turns it on?

thanks
scott

 

[villy]

yes...

 

[Matty]

Hi,

-Will a formular written in VBA process a lot quicker than in a cell in excel?

Are you just talking about a formula written into a Cell via a macro? If so, whether the formula is "manually" entered or written in by a macro, the time it takes to process once in place will be the same.

-Is is posible to turn off screen updating vir a macro and leave it off untill a second macro turns it on?

Have this at the start of your code (after you've declared your Variables):

Application.ScreenUpdating = False

And then this at the end (before End Sub):

Application.ScreenUpdating = True

Hope this helps.

Matty