Hi!
I cant seem to make a "short and reliable" worksheet modifier on excel.
Idea is to delete the entire rows if even one of the values corresponds
to N.

Example:
1a Y
1a Y
1a Y
1b Y
1b Y
1b N
1b Y

If there is even one N on the range(1a to 10a) delete all the rows
corresponding to that range.
In this example all rows under 1b would be deleted.
This will be applied to N sheets, so doing it manually(how I started)
results in very messy code and the range might change in the future to
include 11a etc.
Ideas?