Thread: Remove filter in worksheets before running code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gootroots gootroots is offline
external usenet poster
  
Posts: 28
Default Remove filter in worksheets before running code
How do I include all sheets in a workbook when running the following:

If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If

Thanks
Reply With QuoteReply With Quote