Populate Combobox with Named Range

[samohtwerdna]

Hello all,

This is im sure a simple question, but I want to populate a comboBox with a named range so rather than:

With cboLookUp
        .List = Range("K2:K236").Value
    End With

I want

With cboLookUp
        .List = Range("JOBNAME").Value
    End With

my problem is that I want "JOBNAME" to only refer to the cells that actually have a value in them so I don't get a populated comboBox with a bunch of blank values.

Any help??