1) Is incorporation of less formulas always a better solution? Or should we also reflect computing difficulty of the formulas used? If we agree with the latter, we can say that the beauty of an excel solution is based on how fast the computation is, how much of memory the operation takes.

2) When should I stop using formulas and give VBA a chance while both solutions are feasible? When you have to use 10 formulas to achieve something easily achievable with VBA, it is clearly wrong not to use VBA. Despite that, I sometimes feel tempted to solve problems only by formulas, because it feels like defeating Goliath with my littleness of David.