Range("A9").autofilter
(assumes A9 is one of the title rows of the data which is filtered.

"peyman" wrote in message
...
hi,
In VBA, how can I restore filter before saving.for example, in sheet1 the
rows10 to 20 are invisible(filtered), I need a code by which
unfilter the worksheet ( all the worksheets,if they are in filter mode)
with
no invisible rows and then save the workbook?
thanks