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" wrote:

Try this.

On any sheet go to InsertNameDefine.

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

On Wed, 20 Sep 2006 13:51:02 -0700, Yan Cossette <Yan
wrote:

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!