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!
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!