ExcelBanter - How do I filter by today's date(changing) and before in a macro?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I filter by today's date(changing) and before in a macro? (https://www.excelbanter.com/excel-worksheet-functions/246980-how-do-i-filter-todays-date-changing-before-macro.html)

Laurie

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?

All times are GMT +1. The time now is 05:59 AM.