News for hackers. Stuff that matters.
Re:Damn Excel – How the 'most important application' is ruin... by omni on Saturday April 20, 2013 @07:33PM (#5583241)
I have seen literally hundreds of Excel spreadsheets from banks, consultancies, and VC firms and I have never, ever seen anyone name individual cells the way you are proposing here. If I had to name individual cells in a monthly model spanning the next 10 years over 250 line items, I'd quit that job.

I'm not saying that Excel can't do it, but a) it sounds like it would take a huge amount of time, so b) it is not practically done in "the real world."

Re:Damn Excel – How the 'most important application' is ruin... by jodrellblank on Sunday April 21, 2013 @11:37AM (#5585165)
If I had to name individual cells in a monthly model spanning the next 10 years over 250 line items, I'd quit that job.

Why would you quit the job over a few minutes of scripting with "WorkSheet.Names.Add"?

http://msdn.microsoft.com/en-us/library/office/ff835300.aspx