News for hackers. Stuff that matters.
Re:Why Marketing and BD Professionals Should Learn to Code by kapilkale on Thursday January 12, 2012 @12:30AM (#3455164)
Most of the time it is because the existing functions are inadequate, so people end up adding new ones in VBA. StringConcat, for example, is far more powerful than the regular concatenate function.

http://www.cpearson.com/excel/stringconcatenation.aspx

Re:Why Marketing and BD Professionals Should Learn to Code by gruseom on Thursday January 12, 2012 @01:30AM (#3455278)
When you say "function" you mean something that just does computation, right? As opposed to code that accesses the Excel object model to create interactive effects, like, say, "click this button to change the background color over there"?

How much VBA could be replaced if Excel gave you the ability to make functions just out of spreadsheet cells? That is: build any calculation you like in a spreadsheet, tell Excel "make this calculation be a function called FOO", then use it wherever you want like a normal function: "=FOO(123,A1)" or what have you.

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

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.)