ListBox RowSource not loading all values

[sharky12345]

I have a range of numeric values currently between N2:N13 and I need those loaded into a Listbox using this;

ListBox3.RowSource = Range(Sheet5.Range("N2"), Sheet5.Range("N65536").End(xlUp)).Address(, , , True)

The issue is that it is only loading the first value, from N2 and nothing else.

I'm using the same method of another column which has values consisting of text and numeric, like this;

ListBox2.RowSource = Range(Sheet5.Range("L2"), Sheet5.Range("L65536").End(xlUp)).Address(, , , True)

that one works fine, so I don't understand why the first one doesn't work - is it something to do with the fact that they are numeric only?

 

[sharky12345]

Disregard guys - not sure what had happened but it's now working fine....

 

[My Aswer Is This]

If you were wanting to load all the values in Sheet(5) column(N) from row 2 to last row with data this is how I do it:

Private Sub CommandButton1_Click()
ListBox1.Clear
Dim Lastrow As Long
Lastrow = Sheets(5).Cells(Rows.Count, "N").End(xlUp).Row
Data = Sheets(5).Range("N2:N" & Lastrow)
ListBox1.List = Data
End Sub