Restoring Filter

P

peyman

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
 
P

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
 
Top