I am trying to turn off any filter that was left on close of the workbook when I reopen the book.
onopen I have this
Set OTEws = Worksheets("OTE's")
'unfilter the sheet
OTEws.AutoFilterMode = False
OTEws.FilterMode = False
OTEws.ShowAllData = True
I keep getting errors. What is the best way to unfilter the sheet so I can get a total row count.