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
|