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