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