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?
|