[AccessD] Syntax for seeing named range in excel

Gustav Brock Gustav at cactus.dk
Sat Jan 21 06:03:44 CST 2006


Hi John

>>> jwcolby at ColbyConsulting.com 20-01-2006 21:08:20 >>>
> Now I need to figure out how to CREATE named ranges when I build a spreadsheet in VBA.

Eh? Isn't this VBA:

-----Original Message-----
Sent: Friday, January 20, 2006 10:31 AM
Subject: Re: [AccessD] Syntax for seeing named range in excel

A Named Range can be created like this:

  ActiveWorkbook.Names.Add "John", "=$C1:$D4" 

or more specific:

  ActiveWorkbook.Names.Add "John", "=NameOfWorksheet!$C1:$D4" 

If that Named Range exists, it will be adjusted to the new range settings.

---

Or have you something else in mind?

/gustav




More information about the AccessD mailing list