A range is generally referred to as A1:A10. It is unclear in your example
what you are referring to. You using N as a value and then using N as the
number of sheets. It is unclear if your values are in a single column or
two or more columns, if 1a is a value in a cell or some designation of a
row.

Row ColA ColB
1 1a Y
2 1a Y
3 1a Y
4 1b Y
5 1b Y
6 1b N
7 1b Y

Might be what your describing, with "1a" (a value in cell A1 for example)
being some code that represents a group and "1b" representing a second
group. Then if any group has a "N" value in column B, then all the rows of
the group should be deleted.

Is that what you are trying to say? If not, then what.

--
Regards,
Tom Ogilvy


"KtM" wrote in message
ps.com...
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?