VBA function performance

[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)

 

[Charles Williams]

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

 

[Alan Nordin]

Thanks,

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

Alan

 

[Alexander Wolff]

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