Elizabeth,

Even though the sheets are part of the same file,
Excel treats them as unique entities.
I think you would have better luck with a macro.

Jim Meagher

----- Original Message -----
From: "Elizabeth Boston" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Monday, June 05, 2000 11:32 PM
Subject: [PCSOFT] Excel Named ranges


>         I'm making myself a workbook in Excel 97... This workbook has
> one page for each day of the week, a summary worksheet, and a
> data worksheet. I would like to be able to quickly highlight all
> the data cells at the end of a week, and delete the data in them
>         Is it possible to name a range of cells that includes more than
> one worksheet?
>         I tried doing this, and it seemed to work, At least the range
> appears in the define range window as
>
> =Monday:Sunday!$A$4:$H$30
>
>  but I seem to be unable to use either the name box or the Go to
> command to highlight this range.
>
> Can this be done?
>
>
>
>       Elizabeth Boston
>    Moderator/Senior Editor
>       The NOSPIN Group
>        [log in to unmask]
>
> "All persons ought to endeavor to follow what is right, and not
> what is established."
>
>   -  Aristotle
>
>                 Curious about the people moderating your
>                    messages? Visit our staff web site:
>                      http://nospin.com/pc/staff.html
>

                Curious about the people moderating your
                   messages? Visit our staff web site:
                     http://nospin.com/pc/staff.html