version is Excel 2000 SP3

-I have a ComboBox on Sheet two of the Workbook.
-The ComboBox has a ListFillRange of "S2:S9" where i have some text
-Depending on the ListIndex value of the ComboBox, the macro copies some
numbers from one area of the sheet to another.

This works fine until:
-Go to first page
-Select one or more rows at the top of the page
-RightClick and delete the selected rows
-Now, going back to the 2nd page where the ComboBox is, the DropDown list is
shorter. Delete more rows on the first page and the DropDown list gets
shorter yet, eventually the whole list is gone.

I cannot reproduce, but try fully specifying the ListFillRange with
Sheet2!S2:S9

--

Regards,
Nigel




"Sunny" wrote in message
...
version is Excel 2000 SP3

-I have a ComboBox on Sheet two of the Workbook.
-The ComboBox has a ListFillRange of "S2:S9" where i have some text
-Depending on the ListIndex value of the ComboBox, the macro copies some
numbers from one area of the sheet to another.

This works fine until:
-Go to first page
-Select one or more rows at the top of the page
-RightClick and delete the selected rows
-Now, going back to the 2nd page where the ComboBox is, the DropDown list
is
shorter. Delete more rows on the first page and the DropDown list gets
shorter yet, eventually the whole list is gone.