RasGhul
Well-known Member
- Joined
- Jul 15, 2016
- Messages
- 797
- Office Version
- 365
- Platform
- Windows
Hi Team,
I have a 200 member data set columns A:I and a combo box with the members names DV. When I select someones name from the combo box I would like to delete that row from A:I. I was tinkering with the selection.delete shift:= xlUp function but couldn't define the needed objects etc. it works when I record a macro but I would like to be able to delete who I select from the Combo box.
Thanks in advance all.
I have a 200 member data set columns A:I and a combo box with the members names DV. When I select someones name from the combo box I would like to delete that row from A:I. I was tinkering with the selection.delete shift:= xlUp function but couldn't define the needed objects etc. it works when I record a macro but I would like to be able to delete who I select from the Combo box.
Thanks in advance all.