View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cousinexcel cousinexcel is offline
external usenet poster
 
Posts: 26
Default Macro / Autofilter / Show All Data

Hi,

I wrote in the macro
ActiveSheet.ShowAllData
but if no filtering is set, I get error message.
Is it possible to say something like
If 'filtered...'

Thanks and regards,

Cousin Excel