3 ms·
Yes on the definition of function. I did also use VBA to make certain visual effects possible (the one I remember was some advanced conditional formatting). On
by kapilkale 15y ago
Yes on the definition of function. I did also use VBA to make certain visual effects possible (the one I remember was some advanced conditional formatting).
On VBA being replaced-- I don't know. It depends who the users you're talking about are. Most people I worked with didn't know any VBA because our models weren't that complicated. I in particular was working on a project that was computationally heavy.
- gruseom 15y agoCan you describe the computationally heavy spreadsheets you made? How many cells, how many distinct formulas (i.e. distinct except for relative references), how many worksheets, how long it took to recalculate? Were you pushing any limits of Excel? Were there annoyances? (My email's in my profile if you'd rather discuss it offline.)