Combo Box

[Guest]

I use a combo box on 1 worksheet and reference an input range from another
worksheet in the same workbok. The length of the input range continues to
expand forcing me to increase the rows of the input range. I have been
unable to do this by editing the combo box input range. I have been deleting
the box, inserting a new box in the same cell and redefining the input range
at that time.
Is there a way to edit (expand) the input range referenced by a combo box
rather than starting at the begining each time?
Any suggestions are appreciated
Thank you.

 

[Andy Brown]

I use a combo box on 1 worksheet and reference an input range from another
worksheet in the same workbok. The length of the input range continues to
expand forcing me to increase the rows of the input range. I have been
unable to do this by editing the combo box input range. I have been deleting
the box, inserting a new box in the same cell and redefining the input range
at that time.
Is there a way to edit (expand) the input range referenced by a combo box
rather than starting at the begining each time?

See http://www.contextures.com/xlNames01.html#Dynamic.