Hello,

I am trying to create a drop down list (validation or combobox; which ever is easier) made up of a range of discontinuous cells.
I wrote a function, called VisibleModels, that selects which cells I want in the drop down list:

Function VisibleModels(Rng As Range) As Range
Dim Cell As Range
Dim Result As Range
Dim NumberofModels As Integer
    For Each Cell In Rng
        If Len(Cell) > 0 Then
            If Result Is Nothing Then
                Set Result = Cell
            Else
                Set Result = Application.Union(Result, Cell)
            End If
        End If
    Next
Set VisibleModels = Result
End Function
This function works perfectly.

I am unsure how to go about getting this result into a drop down list. I am using excel 2003.
I think I either need to code this into a combobox (somehow..) or make the result show up, continuously, in a column (My Worksheet is "Models" and I have Column "A" empty) so that there are no formulated blanks in between each item so that data validation will work.
I spent several days and countless hours looking around other sites and I need some help...