Hi again,

We are obviously in a very different time zone and hense the delay in some
of my replies. It is currently 7:30am here. I have to go out for a couple of
hours and then I will get back on this to provide the answer as soon as
possible. I think that I understand now what you are trying to achieve.
However, I would like you to do one more thing for me and then perhaps we can
be sure of getting it correct. (I should have thought of this with my last
post because it is the best way to tell me exactly how you want the filters
set).

In your Records sheet ensure that all filters are set to All. (Turn
AutoFilter off then on again).

Turn on the Macro recorder.
Set the required filters manually.
Turn off the Macro recorder.
Post the code exactly as recorded.

--
Regards,

OssieMac