URGENT: Name Range

[MAS_GSW]

Will someone please guide me with the name range function in Excel 2007. I am
trying to finish a worksheet using the name range function and its not
working for me. THanks for your help!!

 

[JE McGimpsey]

Will someone please guide me with the name range function in Excel 2007. I am
trying to finish a worksheet using the name range function and its not
working for me. THanks for your help!!

Since this newsgroup is dedicated to XL for Macintosh (hence the .mac.
in the newsgroup name), you might find a better response in a WinXL
group, say

microsoft.public.excel.misc

I'm not familiar with "the name range function", though I'm certainly
familiar with named ranges. Perhaps if you were more explicit about what
you've tried, what results you've gotten, and what you expected, it
would be clearer.

 

[CyberTaz]

Well, you've landed in the group for Mac Excel so you will do better if you
get into the PC Excel group which you can do from this link:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

When doing so it will help to be far more specific about what you are trying
to do, how you are going about it & what is or isn't happening as a result.

There is no "name range" *function* as such, but if you mean that you are
trying to create a named range the process is relatively straightforward in
any version of Excel:

Select the range of cells
Click in the Name Box (where the active cell reference normally displays at
the left end of the Formula Bar)
Type the name you want to use (no spaces, symbols or punctuation marks other
than _ as a placeholder for a space - but it's preferable any more to use
upper & lower case, such as MyName rather than my_name) then press Enter.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 10/13/07 1:02 PM, in article
(e-mail address removed), "MAS_GSW"

Will someone please guide me with the name range function in Excel 2007. I
am
trying to finish a worksheet using the name range function and its not
working for me. THanks for your help!!

 

[JE McGimpsey]

There is no "name range" *function* as such, but if you mean that you are
trying to create a named range the process is relatively straightforward in
any version of Excel:

"relatively"?

Note that by default, Bob's method creates an absolute reference (e.g.,
it always refers to the same cell on a specific sheet). One can also
create a relative referenced named range. For instance, with B1 the
active cell, choose Insert/Name/Define:

Name in Workbook: CellToLeft
Refers to: =A1

Then whenever the name is used, it will refer to the cell to the left of
the cell it's used in, e.g.,

D1: =CellToLeft * 2

will multiply C1 by 2 and return the value to D1. If the name had been
entered when D1 was active, CellToLeft would refer to the cell two cells
to the left of the referring cell.

You can also define a reference that is absolute with respect to the
cell address, but relative with respect to the sheet. In the
Insert/Name/Define dialog, enter

NameInWorkbook: MyA1Reference
Refers to: =!$A$1

then when used on Sheet1, MyA1Reference will refer to Sheet1!A1, but
when used in Sheet3, MyA1Reference will refer to Sheet3!A1.

Note that this technique creates one type of named range - specifically
a range associated with a Workbook level name.

You can also create a Worksheet-level named range by including the name
of the worksheet in the namebox or Insert/Name/Define entry, e.g.,:

Sheet1!MyName


Then one can create a dynamic named range by entering a formula that
returns a range in the Insert/Name/Define dialog, e.g.:

Name in workbook MyDynamicName
Refers To: =OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),1)