With Sheets("Coding")
CCFCLC.cmbcc.RowSource = _
.Range("B12",.Range("B12").end(xldown)).Address(ex ternal:=True)
End with

--
Regards,
Tom Ogilvy


"Shawn" wrote in message
...
Here is my code:

CCFCLC.cmbcc.RowSource =
Sheets("Coding").Range("B12:B29").Address(external :=True)


I would like the .Range("B12:B29") to be something like
("B12:B12.xldown")

??

--
Thanks
Shawn