AutoFiltering Multiple Sheets?

hi Sarge,

I think that Dave's code in post number 4 will have problems if there are any completely blank rows or columns within each of the spreadsheets because the use of "With WS.Range("A1")" rather than the complete range means that Excel will "guess" what to sort using the current region.

Before Dave's code will do anything, you have to make the macro start somehow, for example when you push a button on sheet 1 after making your changes. However from some experiences I've had when sorting data with formulae within the range, I think you may find you still have problems due to the formulae references being messed up...

Can you please attach a sample workbook (with no confidential data) for us to investigate?
(hopefully in a PC compatible format or I can't help)

Dave
Just curious, why have you dimmed the ws as an object rather than a worksheet (is it something to do with the object model in Mac's)?

Rob

Yes, it should have been worksheet not object...