How to assign the same name to different rangesof sifferent sheets?

[PATRIK]

Hi all!
my question is: I have a workbook with several worksheets. For each worksheet of the workbook, I want to assign the same name to a range of cells, for instance I want to name this range always: "area". How to do?

Now I jumped the problem in this way. Let's imagine I have a workbook with only one sheet containing a range called "area". I copy this first sheet in the same workbook, so this second sheet will contain a range called in the same way (area) too. But I hope there is some more intelligent way to work.
Can you help me?
Thx a lot

Patrik

[swatsp0p]

This is also called a 3-D reference (3-D reference: A reference to a range that spans two or more worksheets in a workbook.).

On the Insert menu, point to Name, and then click Define.
In the Names in workbook box, type the name (area).
(IF the 'Refers to:' box contains a reference, select the equal sign (=) and the reference and press BACKSPACE to delete it.)
In the Refers to box, type = (equal sign).
Click the tab for the first worksheet to be referenced.
Hold down SHIFT and click the tab for the last worksheet to be referenced.
Select the cell or range of cells to be referenced.

Click OK to close this box.

NOTE: This is ONE range named "area" that encompasses multiple sheets. This is NOT different sheets, each with a range named "area". Each workbook, regardless of the number of sheets it contains can have only ONE range of each name.

Example: Your range "area" is two cells on three sheets (A1 & A2) and you enter the number 5 in each cell. The function =SUM(area) {regardless of where entered} will return 30, not 10.

If this doesn't meet your needs, an option is to name worksheet 1 as "area1", sheet 2 as "area2" and so on.

HTH