Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VBA function performance

0 views
Skip to first unread message

Alan Nordin

unread,
Nov 6, 2009, 1:47:29 PM11/6/09
to
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
alan_...@comcast.net

Charles Williams

unread,
Nov 7, 2009, 4:02:21 AM11/7/09
to
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" <alan_...@comcast.net> wrote in message
news:%23i5mYGx...@TK2MSFTNGP06.phx.gbl...

Alan Nordin

unread,
Nov 7, 2009, 2:44:09 PM11/7/09
to
Thanks,

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

Alan

"Charles Williams" <Cha...@DecisionModels.com> wrote in message
news:4af5379c$0$2485$db0f...@news.zen.co.uk...

Alexander Wolff

unread,
Nov 23, 2009, 6:34:51 AM11/23/09
to
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
--
Moin+Gruss Alexander - MVP for MS Excel - www.xxcl.de - mso2000sp3 --7-2


0 new messages