Elizabeth, you can certainly create a 3D named range just as you say, and
use it in formulae. But I also find that it doesn't appear in the name box.

Here's the easiest way I have found: create a named range for just
=Monday!$A$4:$H$30. When you want to delete the values, click on the Monday
tab, hold SHIFT and click on the Sunday tab - this selects all the sheets -
then click on your named range in the name box. Surprisingly, this selects
the same range in all selected sheets. Press delete and you're done.

Of course, recording a macro is easier in the long run.

Joe

> -----Original Message-----
>         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.
>
>       Elizabeth Boston

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