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

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



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

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

Barb Reinhardt



"J.W. Aldridge" wrote:

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

.

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.

.

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.

.

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.

.

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


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