Naming a cell

[Cossette@discussions.microsoft.com Yan Cossette]

How to give same name to a cell in multiple sheets at the same time

I did try to group all the sheet at the sametime and name the cell, but it
did not work, each of my sheet have different name?

Need Help!

[Gord Dibben]

Try this.

On any sheet go to Insert>Name>Define.

Type in a name like thecell

In the "refers to:" box enter =!$A$1 and OK

On any sheet F5 and type in "thecell"(no quotes) to go to A1 on that sheet.

Or use thecell in a formula on any sheet.

Gord Dibben MS Excel MVP

[Dave Peterson]

I don't think you can manually.

But you could use a macro:

Option Explicit
Sub testme()

Dim myAddr As String
Dim wks As Worksheet
Dim myName As String

myAddr = "c3"
myName = "SomeNameHere"

For Each wks In ActiveWorkbook.Worksheets
With wks
.Range(myAddr).Name = "'" & .Name & "'!" & myName
End With
Next wks
End Sub

--

Dave Peterson

[Dave Peterson]

ps.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

--

Dave Peterson

[Yan]

I know but what i am trying to do is to name same cell same name in 26 sheets
cause, i am doing a DARTS SCORE program and need to refer to those cells,
for different players

I take is score from his sheet, and value it in another main sheet!

[Gord Dibben]

Don't understand your request.

If you want same name same cell all sheets, how will you distinguish which
player you are referring to on which sheet?

Gord

[YAN]

After, i created the name i go and change just the team # or Player #
Yan!

[Gord Dibben]

Where will you change just the team# or player#?

I guess I am just too thick to understand what you are requesting.

Hopefully someone will jump in and come up with an answer for you.

Gord

[RagDyeR]

I'm assuming that you're looking to assign (create) a *sheet specific* name
to a cell, where that name will be the *same* in all sheets.

To create *WS specific* names to a cell, select the cell, then click in the
"name box" (left of formula bar), and enter the sheet name, followed by an
exclamation point, followed by the name you wish to use.

For example, select A1, then click in the name box, and type:

sheet1!mycell

Now, "mycell ' refers to A1 *on* Sheet1 *in* Sheet1 *only*.
"mycell' entered in Sheet2 gives a #Name? error.

To assign the name "my cell" to a cell on Sheet2, you have to repeat the
process of selecting the cell in Sheet2, and prefixing the name of the cell
in the name box with the sheet name.

That's *if* the *same* name will reference a *different* cell in each sheet.

If you create a WS specific name in a sheet, and *copy* that sheet, the
copied sheet will contain the *same* WS specific name, referring to the
*same* cell (range).

HOWEVER ... IF *all* sheets are to contain the *same name*, referring to the
*same cell*, BUT all your sheets are *already in existence*,then you can
"globally" assign a WS specific name to all sheets using this procedure:

From *any* sheet:
<Insert> <Name> <Define>
And in the "Names In Workbook" box enter:
mycell
And in the "Refers To" box enter the cell (range) references with this
formula:

=Indirect("A1")

Then <OK>.

This will make the name WS specific on *all* WSs in the WB.

If I guessed wrong, and if this isn't what you're looking for, I did get a
lot of typing practice!<bg>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"YAN" <Y...@discussions.microsoft.com> wrote in message
news:F8EDC065-0125-4408...@microsoft.com...