Hi,

You can't do that because named ranges must be unique even if on different
worksheets.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"J.W. Aldridge" wrote:

For each new sheet created (workbook code), paste named range "apples"
at the next available/empty row in column A.

.