[AccessD] Syntax for seeing named range in excel

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
> 




More information about the AccessD mailing list