Microsoft KB Archive/160206

= Reference for ListFillRange Does Not Update Properly =

Article ID: 160206

Article Last Modified on 5/8/2002

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



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.



RESOLUTION


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.

Additional query words: XL97 8.0 fill range defined name listbox drop down dropdown combo combobox

Keywords: kbprb KB160206

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.