SamT
01-10-2010, 01:51 PM
Is there any system where I can have a Range Name, (ex: Cat_1,) that encompasses 1 or more Columns where Range Name Cat_1_1 is one of those columns.
I want to refer to Cat_1.Cat_1_1 or something like that.
Even if I can do something like Var = Cat1_Group.Names(i) it would help.
I have a situation, accounting, with multiple levels of header titles and I want to be able to Drill Down.
I have considered; checking Fill Colors where each heading's fill colors extend across the columns it relates to; And a left and right border at the ends of its' area.
While there will always be a top level and a bottom level, there might be missing mid-levels. The bottom level headings will always refer to a single column.
The idea is to open a Form that ListBoxes Workbook Names, (accounting type,) Generate a ListBox of Worksheet Names for the selected WB, then do the same with top level Column heads and repeat down to the bottom level names.
Finally, I'll need an info bar, maybe the Title bar, to iterate the qualified location, by name, of the selected column. Ex: Expenses>>Shop>>Cleaning_Supplies>>Rags where "Expenses is the Workbook Name; "Shop," the Sheet Name; down to the Column/Range Name "Rags."
OK, I think I can do that part myself. LOL
Thanks
SamT
I want to refer to Cat_1.Cat_1_1 or something like that.
Even if I can do something like Var = Cat1_Group.Names(i) it would help.
I have a situation, accounting, with multiple levels of header titles and I want to be able to Drill Down.
I have considered; checking Fill Colors where each heading's fill colors extend across the columns it relates to; And a left and right border at the ends of its' area.
While there will always be a top level and a bottom level, there might be missing mid-levels. The bottom level headings will always refer to a single column.
The idea is to open a Form that ListBoxes Workbook Names, (accounting type,) Generate a ListBox of Worksheet Names for the selected WB, then do the same with top level Column heads and repeat down to the bottom level names.
Finally, I'll need an info bar, maybe the Title bar, to iterate the qualified location, by name, of the selected column. Ex: Expenses>>Shop>>Cleaning_Supplies>>Rags where "Expenses is the Workbook Name; "Shop," the Sheet Name; down to the Column/Range Name "Rags."
OK, I think I can do that part myself. LOL
Thanks
SamT