Ok...I've searched the board looking for a similar quesiton on this issue, but cannot seem to find the answer, so here goes:
From the Combobox, the user can select a name from the Range.
The entire row containing the name selected is to be cleared from the Range and then the Range is to be re-sorted alphabetically, when the user selects 'OK'.
Apple 20
Banana 30
Pear 40
Strawberry 50
When Pear is selected, it is cleared from the range and the Range is now
Apple 20
Banana 30
Strawberry 50
Thanks.
From the Combobox, the user can select a name from the Range.
The entire row containing the name selected is to be cleared from the Range and then the Range is to be re-sorted alphabetically, when the user selects 'OK'.
Apple 20
Banana 30
Pear 40
Strawberry 50
When Pear is selected, it is cleared from the range and the Range is now
Apple 20
Banana 30
Strawberry 50
Thanks.