Hi
Hope somebody can help here.

We run a large drama group, lots of different classes etc. All info relating
to students is on a spreadsheet (Excel 2000) - names, addresses, phone
numbers etc. It also contains data on who has signed up to this terms class.
The class teachers get an attendance register printed from the spreadsheet.
I have a macro that hides those columns of data that the teacher does not
need to see. At the moment all students that were in a class last term are
printed out , even those who have not yet 're-enrolled' in the class.
How can I print only those rows where the the entry in the column for
enrolment status is showing 'Re-enrolled'?
Ideally I want to add to the print area macro I have written so this hiding
of unwanted rows happens automatically rather than have to manually hide
using filters or whatever. (As we have 29 classes and 500 students a manual
system is a bit onerous).

I did find a piece of VBA script that might have done the trick in a
discussion group - but now I can't find it!

Thanks in advance