Thread: unfilter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
peyman peyman is offline
external usenet poster
 
Posts: 189
Default unfilter

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