cell formula vs VBA code

[S_Wish]

Hello everyone! As I looked through "Excel Questions" forum, I was amazed by variety of cell-formulas' usage (don`t know if named it right. its smth like writing in c1 "=a1+b1") along with VBA codes.
What is the advantage of cell formulas? only time? or there is something else?

 

[J.Ty.]

This post was intended to make the list of reasons for using formulas rather than VBA code as complete as possible. Please feel free to add more arguments if you wish

J.Ty.

 

[ZVI]

Sounds like do someone like more formula-daughter or VBA-son? I like both.
Choosing of VBA or formula solution depends on tasks.
Sometimes they can be even combined to make solution simpler or easy in understanding.
Regardless VBA does not support multi-threading, using VBA on huge data can be much faster than formula solutions.
But with formulas all can achieve fast, good and a working result without any skills in programming.
BTW, formulas like chess are good for a brain

 

[taurean]

Good points J.Ty.!

For any customized (in this case VBA based) solution, it is required to "maintain" as the future software upgrades come in. A functionality which was unavailable in previous versions may get introduced in the later version. So with version upgrade, macros may not work (sometimes!) or may become redundant. This maintenance perspective should be taken into account. But largely built-in functions will not face this.