Wonder if the OP meant a 3D range

Refers to: =Sheet1:Sheet3!$A$1:$C$3

Not sure if a Name that defines this refers to a Range
(not according to the Immediate window), a Reference to a
group of ranges with different parents, or a Formula

Regards,
Peter

-----Original Message-----
I'd call it a Name, but not a Range.

Range's have a bunch of properties (like .parent) that
this Name doesn't have.


Bernie Deitrick wrote:

Dave and Charles,

You can have a named range that refers to Sheet1!A1 and
Sheet2!A1, but not
Sheet1!A1 and Sheet2!B2. I'm pretty sure that is what
the OP was talking
about....

HTH,
Bernie
MS Excel MVP

"Dave Peterson" wrote in message
...
I thought Steph was asking about a named range.
(Insert|name).

And I can have a name that refers to cells from two
different worksheets:

I used this in the refers to box in that dialog:
=Sheet2!$A$1,Sheet1!$A$1

But that's not a range--but it is a name.

I guess it boils down to what Steph really meant.

Steph?

Charles Williams wrote:

Hi Steph,

=sum(Sheet1!a1,Sheet2!A2,sheet3!a3)

this works OK, not sure what Bernie sees as a
problem.

Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com


Yes, as long as they are the same cells on each
worksheet: Sheets 1
to
Sheet 2 cell A1 is OK, Sheet1 cell A1 and sheet2
cell B2 is not OK.

HTH,
Bernie
MS Excel MVP

"Steph" wrote in message
...
Can a single named range include cells from
multiple sheets?





--

Dave Peterson


--

Dave Peterson

.