Delete selected range in listbox and the corresponding Range in worksheet and shift cells up

**royUK** · Apr 26th 2021

Why do you load the ListBox with an array then load it using RowSource? Since you're using the RemoveItem method you must load your listbox range using it's List property and not the RowSource.

zubinnajmi · Apr 27th 2021

Thanks Roy......I will look up this matter...

**Carim** · Apr 27th 2021

Once you have totally ' transposed ' the solution to your real-life workbook ... please do not hesitate to post your feedback

**Carim** · Apr 30th 2021

Message # 35 suggested a working solution ...

Since then ... have you managed to include it in your real-life workbook ...???

Delete selected range in listbox and the corresponding Range in worksheet and shift cells up

Participate now!

Share