Same cells in multiple ranges.

[Jo-Jo]

Hi all,

RANGES

Can separately defined/named ranges contain some of the same cells without any adverse effects or pitfalls?.

e.g.:-
range_No1. cells A1 thru C3
range_No2. cells B1 thru D3

Thanks,
J.

[sweep]

Hi,

I have a couple of worksheets where one named range is a subset of another. I have no problems with either.

[dominicb]

Good morning Jo-Jo

Can separately defined/named ranges contain some of the same cells without any adverse effects or pitfalls?

I believe that it is quite OK to use named ranges where one range is contained within another, or where one range overlaps with another. In VBA the Intersect command is used to determine this, and the Excel Help files document it's use using named ranges, so I guess they've thought of that ...

HTH

DominicB

[rwgrietveld]

Agree, One thing not many people know is that SUM() works with intersections:

=SUM(List2by3 List2by1)

List2by3 refers to A1:C2
List2by1 refers to B1:B2

The space in the SUM function makes it an intersect.

[Jo-Jo]

Hello sweep, dominicb and rwgrietveld,

Thank you very much for the replies and for clearing it up for me.

Appreciated.
J.