Hi,
I have written a macor that creates a drop down list in cell F2. Because the range is dynamic (it varies between 1 to 10 cells), the list contains the values of the range F2:F10. As a result the list conmtains many empty spaces.
I would like the list to show only the values of the cells below F2, so if there are 5 values the list should contain only these 5 values. I guess i should change something in the line : 
 xlBetween, Formula1:="=$F$3:$F$10"
How can i adapt my macro for attaining this goal?

        Range("F2").Select
    With Selection.Validation
        .Delete
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:="=$F$3:$F$10"
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True
    End With