VBA function performance

  • Thread starter Thread starter Alan Nordin
  • Start date Start date
A

Alan Nordin

Hello,

I'm using Excel 2007. I have a very large spreadsheet {.xlsx}. Two of the
columns contain a somewhat long formula {mostly string manipulations}. I'm
wondering what the benefits and drawbacks would be if I were to convert the
formulas into Visual Basic functions. Mostly I'm concerned with performance.
The sheet does take some time to load, calculation is almost instantaneous.

Alan
(e-mail address removed)
 
Try using .xlsb for faster loading.

If calculation is almost instantaneous there I would not bother to convert
formulas into VBA functions.


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
Thanks,

I guess I need to look at the options in the "Office Button" a little more
closely.

Alan
 
Why not use a single formula for the column which a workbook_open or a
manually executed vba-sub converts into columnwide formulas?

You get

1. a very small worksheet, which is fast loading
2. fast execution of copied formulas, rather than vba
 
Back
Top