Reference for ListFillRange Does Not Update Properly (160206)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q160206 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.
RESOLUTIONWORKAROUND
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.
| Modification Type: | Major | Last Reviewed: | 5/8/2002 |
|---|
| Keywords: | kbprb KB160206 |
|---|
|