combo box population question

[indiana115]

i have active x combo boxes set to populate through a list on a seperate worksheet. in the properties of the combo box is there a means to have it populate in a dynamic range as the list size can change. it is current set from a1:a200 to cover anything currently in use but has many blank spaces right now wanting to set it as a1:a(last cell with data) thanks

[protonLeah]

create a dynamic named range using such a formula as:

Please Login or Register  to view this content.

(replace list data with the name of the sheet with the list)

use that name in the ListFillRange