Range question in '97
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
|