Hello people
I'm curious to know peoples thoughts on using formulas vs using VBA - I'm asking in respect to general use spreadsheets, rather than excel bots running high frequency trades. I did some quick research into this topic a few months back, and the opinion of the 'internet experts' was along the lines that formulas were quicker for all but complex spreadsheets, as formulas could be read natively by whichever language Excel is written in, whereas VBA is a language running on top of Excel. Programming is above my pay grade, so that could be a load of nonsense for all I know...
For you experienced Excel users, or anyone with thoughts on the subject:
- Are there any speed and/or efficiency advantages to using VBA over formulas?
- is it better to do all calculations entirely in VBA, then populate cells with the output?
- is a combination of the two the best compromise? (i.e. using VBA to write formulas only where needed?
I guess the next logical step for my workbooks is the latter question - to use VBA to enter formulas only where needed - there's no point having say, 20 rows and several columns of IF statements to read through in a five horse race. Nig299 posted some VBA lessons here a while back - wherever you are Nig299, thanks!
Cheers
adenlark