Andy Lacey
andy at minstersystems.co.uk
Fri Jan 20 16:06:31 CST 2006
They were even in early versions of 123 when I was doing major stuff with that decades ago. /Range Name .... Aaaah, memories! -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Charlotte Foust > Sent: 20 January 2006 19:12 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Syntax for seeing named range in excel > > > It's funny, but named ranges have been around since at least > Excel 5 that I can remember, maybe longer, and yet they seem > to be so obscure. I don't use Excel much, but I did at one > time, and I couldn't have built the pseudo-databases I did > (for Macs at the time, which didn't have much of the real > thing) without making extensive use of named ranges. They're so EASY!! > > Charlotte Foust > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Gustav Brock > Sent: Friday, January 20, 2006 11:05 AM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Syntax for seeing named range in excel > > > Hi John > > Nice to hear. Please let me leave that as the quote of the week! > > However, I haven't missed an opportunity to mention this through the > years(!) - speaking for deaf ears? > > So, everyone else, Named Ranges are so simple to apply and > use, the feature has been there since "forever", but still > most users and many programmers don't know about it, thus > wasting time hammering primitive cell coordinates into > formulas and code. > > /gustav > > >>> jwcolby at ColbyConsulting.com 20-01-2006 19:40:29 >>> > > I just really discovered named ranges and boy is THAT cool, > even inside the spreadsheet. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >