View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] excel@shoenfeltconsulting.com is offline
external usenet poster
 
Posts: 7
Default Code to determine if data is filtered

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.