Code to determine if data is filtered
With activesheet
If .FilterMode Then
.ShowAllData
End If
end with
or just ignore the error:
on error resume next
ActiveSheet.ShowAllData
on error goto 0
" wrote:
What code could I use to show all rows in the data filtering, IF data
filtering is on. I tried,
ActiveSheet.ShowAllData
but then it bombs if nothing is already filtered.
--
Dave Peterson
|