Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic, conditional chart creation from separate files [Excel2007] | Excel Programming | |||
Naming Conditional Sum Formulas | Excel Discussion (Misc queries) | |||
Creation of a range with no specified address | Excel Programming | |||
Naming objects on creation | Excel Programming | |||
Conditional Checkbox Creation on a UserForm | Excel Programming |