View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter-Jon Peter-Jon is offline
external usenet poster
 
Posts: 1
Default Macro with custom autofilter for greater and less than specific da

Hi

I am trying to record a macro where I autofilter a column containing dates.
I need to apply greater than and less than to get a specific month eg.
greater than 11/01/06 and less than 11/30/06 to get the info for the month of
november. When I record the macro and run it I find that there is no data
displayed yet when I autofilter without the help of a macro then the
information is there. Anyone have any ideas what I'm doing wrong?