garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Hi,
I have the below VBA which will look at Column A and delete any row that has an exact match for Vacant
Is there a simple way I can get this to delete a row which contains the word Vacant (so Vacant 1, Vacant 2 etc etc). So pretty much a partial match but only if the word "Vacant" appears in the column.
Thanks
Gary
I have the below VBA which will look at Column A and delete any row that has an exact match for Vacant
Is there a simple way I can get this to delete a row which contains the word Vacant (so Vacant 1, Vacant 2 etc etc). So pretty much a partial match but only if the word "Vacant" appears in the column.
Thanks
Gary