paste named range on each sheet created

[J.W. Aldridge]

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

 

[JLGWhiz]

ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1,0) = "Apples"

 

[Barb Reinhardt]

You're going to need to describe what you want in a bit more detail.

Barb Reinhardt

 

[Mike H]

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.

 

[Peter T]

The question doesn't make sense, by definition the first empty row on a new
sheet will always be row-1 (and the first empty column also 1 not that you
specified which column you want to paste to).

In addition to clarifying the above confirm the named range "apples" is a
workbook level name that you have already defined, and that the range refers
to a single area (or otherwise).

Regards,
Peter T

 

[Barb Reinhardt]

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]

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.