Getting Started: Thinking Outside the Cell
Jordan Goldmeier, Purnachandra Duggirala · Apress eBooks · 2015
In this chapter, I’ll talk about some misconceptions concerning Excel development. It’s quite often heard that Visual Basic for Applications (VBA) is where all “advanced” Excel takes place. The thought is VBA can do everything, and if you want your data to be sorted, manipulated, and so forth, you’ll need VBA. But you should think of Excel formulas and VBA not as separate entities but as tools that should work in tandem to present the best result. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.