XL97: Reference for ListFillRange Does Not Update Properly

• Microsoft Excel 97 for Windows

SYMPTOMS

The ListFillRange property of an ActiveX control does not update properly when rows or columns in the ListFillRange are inserted or deleted.

CAUSE

This problem occurs if the ListFillRange references a named range. When the ListFillRange property refers to a named range, it refers to the original set of cells defined by the named range and does not track inserted or deleted cells.

For example, if your worksheet contains a named range called MyRange that refers to A1:A5, and the ListFillRange property is set to the named range MyRange, then the ActiveX control always refers to A1:A5 and does not adjust when you insert or delete cells. If you delete cell A2, the named range MyRange updates to refer to A1:A4, but the ListFillRange property of the ActiveX control still refers to A1:A5.

WORKAROUND

To work around this problem, use either of the following methods:

• Directly reference the range for the ListFillRange property rather than using a named range.

      -or-
  

• Save and close the file. The ListFillRange on the control will update when you open the file.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.