I can't remember if XL97 has an issue with that method or not....

You might try starting on Sheet2 when you use the Advanced Filter and select
the ranges on the other sheets, instead of using the range names.

If that doesn't work, then...XL97 may have a problem referring to other
sheets with the Advanced Filter.

***********
Regards,
Ron

XL2002, WinXP-Pro


"Joe" wrote:

Nope ..that didnt work. :(

Does this have something to do with the fact that I'm using Excel 97 ?

-Joe.