Hi, (I might have figured this out a long time ago, albeit slowly, but I was never very good at VBA) :(
I have the same advanced filter on a few worksheets (in same workbook) and I need the auto-filter to immediately auto-run when the worksheet is opened. That is, when a worksheet that has an advanced filter set in it.
Can you help please.
BTW: If you want a copy of the workbook please yell & I'll have to dummy one up for you (as it's confidential data).