On Wednesday, April 16, 2014 8:43:29 AM UTC-7, GS wrote:
On Wednesday, April 16, 2014 7:14:42 AM UTC-7, GS wrote:

Howard,



It appears that you are trying to use dynamic lists without defining



the ranges with names. IMO, it's better to define the ranges as

dynamic



and just use the names in the DV dialog. OR am I missing something



here?







--



Garry





You are correct, but how would I pass the named ranges to the desired

column DV?



Howard



Via the DV dialog? Or is there some reason you need to do this via

code?



--

Garry


Yes, I wanted to use code to do something like this from Claus' suggestion.

With Range("A1:E1,G1,J1")
** seven +/- DV's **
End With

Where I was running a loop 5 times offsetting the DV code to each column.

Howard