samohtwerdna
09-13-2005, 09:15 AM
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??:doh:
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??:doh: