Dynamic Range Problem

[DonG]

Hi Again,

I've created a form with a combobox on it. I've named a range using the code below. My problem is that when data is added it doesn't show in the combobox until I save and close the WB. Upon reopening the WB, the drop down contains all the original data and the added data.

This is the code I used to create the named range:

=OFFSET(Sheet2!$B$2, 0,0, COUNTA(Sheet2!$B:$B)-1,1)

What command am I missing or is this normal behavior for a dynamic range drop down list?

TIA, Don