A
art
Hello:
How can I set a combo list to a range in a certain sheet that the length of
the range keeps changing and new names are added to the list?
For e.g. the list starts off from I2:I10, however I keep adding to the list
and I want the combobox to add the newer ones to the list as well. I started
using ComboBox1.ListFillRange = MyRange, which is I2:last cell in this column?
Any help?
Thanks.
Art
How can I set a combo list to a range in a certain sheet that the length of
the range keeps changing and new names are added to the list?
For e.g. the list starts off from I2:I10, however I keep adding to the list
and I want the combobox to add the newer ones to the list as well. I started
using ComboBox1.ListFillRange = MyRange, which is I2:last cell in this column?
Any help?
Thanks.
Art