Range question in '97
Works perfect
Thanks
"Gord Dibben" <gorddibbATshawDOTca@ wrote in message
...
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
|