How can I pinpoint the location of a Cell within a Table, and delete the row underneath it? I have vertically merged cells, and apparently the Rows collection fails.
The Cell contains a keyoword such as: "Application Domain " or "Subdomain " and I want to delete the row under the cells which contain any of these strings.
Should I look into a Macro that uses the Search Function, or somehow run through each cell of the Table?
What is a clever way of dealing with this?
Thank you very much,