ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   RowSource for Combobox Improvement (https://www.excelbanter.com/excel-programming/386008-re-rowsource-combobox-improvement.html)

Tom Ogilvy

RowSource for Combobox Improvement
 
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





All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com