View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Laurie Laurie is offline
external usenet poster
 
Posts: 37
Default How do I filter by today's date(changing) and before in a macro?

I'm trying to create a macro to sort a list by everything that is today's
date and before. I want to highlight them once this is done, so filter seems
the quickest method. What can I imput to be the changing date in the filter
by field?