Names across worksheets

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I am defining groups of cells as a name by using these
steps, "Insert", "Name", "Define". This works great when
I'm on the one worksheet, though I find a brief problem
when I try to span across worksheets.

I've taken 6 cells from one worksheet and one from
another. If I do a normal sum, the answer is 1795. If I do
a sum on the defined name, it comes to 3595.5. I thought
for some odd reason that the result was doubled, but it's
more than doubled (only just). If I simply do =(defined
name), it comes out to the value of the final cell (on the
separate worksheet).

Thank you in advance,
-Kevin.
 
First, I find working with defined names difficult because of the
userinterface. I really like the utility that Jan Karel Pieterse, Charles
Williams and Matthew Henson created.

You can find it at:
NameManager.Zip from http://www.bmsltd.co.uk/mvp

It makes checking names a lot (a real lot!) easier. (Checking via
insert|name|Define is a pain.)

And I've always kept my range names limited to one sheet. If I need to add
cells in different worksheet, I'll use a range name per sheet.
 
Back
Top