range naming and conditional creation

  • Thread starter Thread starter CellShocked
  • Start date Start date
C

CellShocked

Hey guys n gals,

I use a lot of named ranges for cells and cell arrays.

I find it particularly archaic that each entry has to be done in a
singular, one at a time fashion. Same thing for validations and
conditionals.

There should be way to do this in a table. Maybe there is, but it
should be part of the base engine, IMO.

So, are there specific programming command which allow for range name
creation or validation or conditionals to be added, edited or removed?

If so, I think I should be able to create a worksheet which has the
data elements and write a script which performs the insertions, edits,
and deletes.

Does this sound feasible? Or is it already going on/code snips around?

Any help would be greatly appreciated.
 
CellShocked said:
Hey guys n gals,

I use a lot of named ranges for cells and cell arrays.

I find it particularly archaic that each entry has to be done in a
singular, one at a time fashion. Same thing for validations and
conditionals.

There should be way to do this in a table. Maybe there is, but it
should be part of the base engine, IMO.

So, are there specific programming command which allow for range name
creation or validation or conditionals to be added, edited or removed?

If so, I think I should be able to create a worksheet which has the
data elements and write a script which performs the insertions, edits,
and deletes.

Does this sound feasible? Or is it already going on/code snips around?

Any help would be greatly appreciated.
Click to expand...


check

Application.Names.Add
 
Given the custom nature of the names feature, I'd be surprised if MS
provides much more than what we got with V12. I use JKP's NameManager
addin extensively and find it the best thing going for this.

As for what I think you're looking for...

I use VBA to setup local names based on a 'setup table' stored on a
hidden worksheet. This is described in the book entitled *Professional
Excel Development* in some detail. I use this to toggle the worksheet
UI settings between devmode and runmode mostly, but it serves to
populate sheets with defined names and set there runtime values at
design time as well.

The table basically lists sheet CodeNames in colA and the desired
DefinedNames as its headings.

The code cycles through the table checking each sheet for the existence
of the name, adds it if need be, and sets its value to what's stored in
the table.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Given the custom nature of the names feature, I'd be surprised if MS
provides much more than what we got with V12. I use JKP's NameManager
addin extensively and find it the best thing going for this.

As for what I think you're looking for...

I use VBA to setup local names based on a 'setup table' stored on a
hidden worksheet. This is described in the book entitled *Professional
Excel Development* in some detail. I use this to toggle the worksheet
UI settings between devmode and runmode mostly, but it serves to
populate sheets with defined names and set there runtime values at
design time as well.

The table basically lists sheet CodeNames in colA and the desired
DefinedNames as its headings.

The code cycles through the table checking each sheet for the existence
of the name, adds it if need be, and sets its value to what's stored in
the table.
Click to expand...

Cool. Thanks. So it appears a recursive creation tool can be coded
rather easily. Thanks again.
 
Back
Top