View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Syndrome Syndrome is offline
external usenet poster
 
Posts: 11
Default Create a macro to run autofilter based on contents of 2 cells

I have a list of dates in column A, starting in cell A3 upto cell A1002. I
have the autofilter in place for column A. I want to run a macro that will
filter these dates to show only the ones that are equal or greater than the
first date that is in cell A1, and also that are equal or less than the
second date in cell B1.
I can filter the information using the custom part of the autofilter, but
I'd rather be able to type the to and from dates in the two cells stated and
press a button to run the macro.

I hope that makes sense. Any help would be greatly appreciated.