J
J.W. Aldridge
For each new sheet created (workbook code), paste named range "apples"
at the next available/empty row in column A.
at the next available/empty row in column A.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JLGWhiz
ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1,0) = "Apples"
B
Barb Reinhardt
You're going to need to describe what you want in a bit more detail.
Barb Reinhardt
Barb Reinhardt
M
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.
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.
P
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
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
B
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
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
M
Mike H
I agree the question never made sense but based upon
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.
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.