Restoring Filter

[Guest]

In VBA, how can I restore filter before saving.I need a code by which
unfilter all the worksheet(if they are in filter mode)and then save the
workbook?
thanks

 

[Pete_UK]

You can just do:

Selection.AutoFilter

This will get rid of the filter pull-downs and restore any rows hidden
by the filter. However, if you don't have any filters on the sheet,
this will set them up.

Hope this helps.

Pete