Custom Lists

  • Thread starter Thread starter hgraning
  • Start date Start date
H

hgraning

I am trying to create a macro that will fill cells with a custom list o
set times. I have already created the custom list, but I don't kno
how to get a macro to do what I want it to do? Any Suggestions???

Thanks!
Heathe
 
Heather,

Try something like the following:

Dim V As Variant
Dim Ndx As Long

V = Application.GetCustomListContents(listnum:=1)
For Ndx = LBound(V) To UBound(V)
Cells(Ndx, 1).Value = V(Ndx)
Next Ndx


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top