View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default i to = column in Formula

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

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion