Re:Why Marketing and BD Professionals Should Learn to Code
by gruseom on Thursday January 12, 2012 @02:25AM
(#3455393)
Can 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.)
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.