I'm working with ComboBoxes (the ones from Controls, not the ones from
Forms). I've defined the ListFillRange as a dynamic range called
Drop_IR. When I first set up the ComboBox, Drop_IR had 42 rows. I've
added 4 rows to this data range (I've checked the size with
Insert...Name...Define that the range is indeed 46 rows now) but the
ComboBox won't display the new entries.


When I delete the Drop_IR reference for the ListFillRange and then
retype it in, it lists 46 rows. I've also noticed that when I save,
close, and reopen the file, the "dynamic" range updates itself. Is
this an Excel bug or am I doing something wrong?

Terry Detrie