On Wednesday, April 16, 2014 10:25:53 AM UTC-7, GS wrote:


I see. The $ symbols need to be removed from the col labels, then,

so the formula adjusts accordingly.

--



That does not work as the formula is "protected" by the " "'s per

this recorded and loop added macro. All the DV lists refer to column

A's values.



Well that makes sense! I didn't realize this was what you wanted.



I agree the hand made solution is better. There is not a huge outcry

for code generated DV's anyway.



True, but still needs to be done when needed. For example, I have an

Invoicing: Simple Bookkeeping app that allows users to customize the

ChartOfAccounts as per the following design...


So you use code to produce the DV's and then 'hand craft' the dynamic ranges to each DV?

Howard