Issue seems simple but i cant find anything. I want to fill an Dropdown selection (in excel not in a userform) with the values of an array.
so far i created the array and now i only want to hand it over to an drop down. Sounds simple enough.

Here the Code for creating the Dropdown

```
Worksheet("Example").Cells(i,13).Select 'original here was a  . range but i need it to be variable therefore i used cells
    With Selection.Validation
        .Delete
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:= ArrayNAme 'not working
        .IgnoreBlank = False
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True

    End With

```

I dont get an error message but also no Dropdown appears. Does somebody know what iam doing wrong?

---

Some good new, some bad news ^^
A Dropdown is now created and filled. Unfortunatlly the filling isnt quite right.

The last value is always a number and the array isnt properly erased when the next loop comes so the picture is like:

First drop down: "correct value", "correct value" "2" 'there shouldnt be a number

Second drop down: "value from first dropdown", "value from first dropdown", "2", "new correct value, ...

I hope this is understanable.
Here my currecnt code. 

```
Dim joinedOutput As String
Dim index As Long
For index = LBound(ArrDropdown, 1) To (UBound(ArrDropdown, 1) - 1)
    joinedOutput = joinedOutput & ArrDropdown(index) & ","
Next index
joinedOutput = joinedOutput & UBound(ArrDropdown, 1)

    Set rng = Worksheets("Transfer").Cells(j, 13)

    With rng.Validation
        .Delete
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:=joinedOutput
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True
    End With

   Erase ArrDropdown

```