Need to make my combobox1 dynamic

[HaroonSid]

hello

i m using combobox1 RowSource = UNIQUE_NAMES ("BM10:BM500")

i want make it dynamic
i mean if have data only BM10:BM20 then in combobox1 shows only range data not all others blank cell and when i update the UNIQUE_NAMES value then auto update the combobox1 ragne
thanx

[MarvinP]

Hi haroon,

You can do this with a Dynamic Named Range. You create the Named Range and use it in the properties of the combobox instead of your "BM10:BM500"

Look at:
http://www.vertex42.com/ExcelArticle...ed-ranges.html to create the DNR

[HaroonSid]

Thanx MarvinP

problem solved