Terry, what you described works perfectly for me in Excel 2002. What version
are you using?

Regards,

Vasant.

"Terry Detrie" wrote in message
...

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