Named Range maker code
On Sunday, December 21, 2014 10:13:53 PM UTC-8, GS wrote:
That's pretty much exactly how the DV lists are laid out in my
Invoicing: SimpleBookkeeping project! Have a look here at
'IncomeExpense.xlt' to see how the ranges are dynamic for the dependant
DV lists on the Expenses worksheet. You'll need the "NameManager" addin
to view the defined names because most are hidden. (I assume that by
now you already have this addin!)
--
Garry
I don't know what the "NameManager" addin is, so I suppose I don't have it.
I have the Income Expense2 open but I'm not seeing anything I can use as a "One at a time dynamic named range maker".
All I really need is the very same code as my first post that will allow me to use row 1 or any other row as the header row for a single dynamic named range.
Howard
|