Opinions on code vs. formulas

[dandyrandy]

Should I use array formulas in my spreadsheets or let vba code do my calculations?
Will this aid in reducing the size of the workbook?
A positive I see: I can control when I want those calculations performed instead of the whole workbook calculating on every data change.
Thanks,
dandyrandy

 

[PaddyD]

Not exactly helpfule but general answer is "It depends..." For some info on the sort of things it depends on, have a browse through:

http://www.decisionmodels.com