.. Then copy the entire sheet (as filtered), do a paste special as
values in a new sheet (only the filtered subset will get pasted over).

The above behaviour applies in my xl 2003. Hazily recollect some postings
that it doesn't quite work that way in xl2007. Just a clarification for the
record.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---