Advanced Filter and VBA

[martywms]

Hello,

I have code for reading and recording existing autofilter parameters on a worksheet, clearing the filter to perform some operation, then re-applying the original autofilter parameters. Now I'm trying to do the same thing with code for advanced filters. I have previously coded setting and clearing advanced filters, but I can't find how to record a previously applied advanced filter where the filter was set by someone else. I need to be able to find and record the criteriarange, but so far I haven't been able to figure out how to do that.

Thanks!

 

[RoryA]

Welcome to the forum.

I am not aware of any way to do that. The filtered range is recorded in a named range, but the criteria range is not always recorded unless it's on the same sheet. If you know it will be on the same sheet then you can look for a range called 'sheet name'!criteria