Can a ComboBox display a Range in a hidden column?

[AndyEd]

I have the below code

Me.cboSelectReferenceNumber.List = .Range("B2:B" & .Cells(.Rows.Count, "B").End(xlUp).Row).value

If I hide Column B, it displays the data within Column C instead. Will it not 'see' the hidden Column?

Thank you

 

[rlv01]

When I fully qualify the range references, it works for me when I hide column B.
(I'm assuming this is a worksheet activeX combo box, not a userform combo box)

Me.cboSelectReferenceNumber.List = Me.Range("B2:B" & Me.Cells(Me.Rows.Count, "B").End(xlUp).Row).Value

 

[AndyEd]

Apologies rlv01, it IS a UserFrom ComboBox.

 

[rlv01]

    With ThisWorkbook.Worksheets("LoanRates")
       Me.cboSelectReferenceNumber.List = .Range("B2:B" & .Cells(.Rows.count, "B").End(xlUp).Row).Value
    End With

It still works normally with a User form combobox. Using a fully qualified worksheet name, data is still loaded from column B, even when hidden. I'm sure you have your reasons for spooning out information one gram at a time, but I'm out. Good luck to you.

 

[AndyEd]

I reworked the Worksheet and ended up looking up from a different list. This time it worked, so I can only assume I must have mistyped something.

Your method does indeed work.

As for 'spooning out' information, I'm not sure I get you? Sometimes I find it difficult to know what's relevant and not, so I see it more of an oversight...

Thanks for your time anyway.