Excel Prize Competition

I don't use spreadsheets very much, but every year we have to produce a demonstrators timetable, and Excel is how we do it.

I've got a very clever spreadsheet that lets you enter things and automatically highlights cells for the demonstrators, counts their loading and all sorts.

I'm quite proud of it.

It uses a named range, called Times, which has all the timeslots in it.

This year we have added modules and moved things around, and now the named range does not reflect the part of the spreadsheet that I want it to.

And nothing in Excel 97 would seem to let me change this.

The help, like always, tells me in mind numbing detail how to do things which are either too simple for words or too complex for me to ever want to use.

I have that sinking feeling in the pit of my stomach that there is a very easy way to do this (in fact I even remember doing it once many years ago) but I don't know what it is.

Very frustrating.

So, I turn to you, dear reader. You have already shown that you are highly intelligent just by the kind of blogs you read (i.e. this one). So prove this by letting me know how to do this "simple" thing. First answer that works wins a Mars Bar.


I really must be careful posting when I'm cross. I meant Office 2007 rather than 97. And I must thank Andy (and the enigmatic Me) for providing the answer, which turns out to be as simple as I suspected it might be.