Adam

Try this..........

On sheet1 InsertNameDefine.

Type in "globalgame"(no quotes)

In refers to box type in =!$A$1:$K$22 and OK your way out.

Go to any sheet and F5. In the reference: dialog Type in "globalgame"(no
quotes) and OK.


Gord Dibben Excel MVP

On Sat, 10 Dec 2005 14:16:21 -0600, "Adam Kroger"
wrote:

a further clarification, can you name a range of cells say A1:K22 game, and
then specify sheet1!game, sheet2!game without haveing to name then on sheet1
and sthhet2 and sheet3...?

"Bob Phillips" wrote in message
.. .
Yes. Select sheet1,

InsertNameDefine...

then in the 'Names in workbook' put Sheet1!game, then add the range in the
Refersto box.

Repeat for sheet2, etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
Can you have sheet specific named ranges?

ie
sheet1!game, sheet2!game, sheet3!game


so they can be referenced in a lookup, pulling values from the correct
sheet.

thanks