I agree the question never made sense but based upon

For each new sheet created (workbook code),

I (probably wrongly) interpreted the range as being workbook too.

--
Mike

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


"Barb Reinhardt" wrote:

You can have the same named range on each worksheet as long as the scope is a
worksheet range, not a workbook range. I've done it a lot. But the
question didn't make sense for what was to be the range.

Barb Reinhardt



"Mike H" wrote:

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.

.