VBAProIWish
Well-known Member
- Joined
- Jul 6, 2009
- Messages
- 1,027
- Office Version
- 365
- Platform
- Windows
Hello All,
Here's my question...
If the cell in the column named "location" says "Europe" or "Canada", and the cell in the column (in the same row) named "office" is blank, delete the entire row.
A couple of things to note....
1. There will be many blank cells, so I would need the search to continue and only stop at the bottommost row with data in column header named "report" as this is always the longest column with contiguous data.
2. The columns may switch around, so I would like the searches to find the cells based on their column header name, not column position.
3. I would like all search criteria to be case iNsEnsiTIve.
Thanks much!
Here's my question...
If the cell in the column named "location" says "Europe" or "Canada", and the cell in the column (in the same row) named "office" is blank, delete the entire row.
A couple of things to note....
1. There will be many blank cells, so I would need the search to continue and only stop at the bottommost row with data in column header named "report" as this is always the longest column with contiguous data.
2. The columns may switch around, so I would like the searches to find the cells based on their column header name, not column position.
3. I would like all search criteria to be case iNsEnsiTIve.
Thanks much!