Help!!
I have a WorkBook with a Sheet that contains lists that are defined as named
ranges. I am using VB within Excel to build a sheet and want to set a cells
validation criteria from the lists.
For Example my Sheet called LISTS has a named range AI810 that has a list of
values 0..20mA, 1..5V, 4..20mA
When I insert a sheet using VB I want to set say cell A2 to the above
validation criteria. I know if I do it by hand you use the
=indirect("LISTS!AI810") and select a List. How do u do it from within VB