There are data in other columns. I can not delete entire rows.
Because there are data in other columns. I can not delete entire rows. I tried deleting cells but cannot.
Your methond is really good except my spread has the special consideration. Thanks a lot for help.