I have a spread sheet which can vary from 8k to 12k lines long.

Row 1 contains header information.

Column Y can contain either blank cells, or cells with dates.

Excel 2003.

I need to run through all the rows, look at the value in column Y, and
determine if it is more than 100 days from todays date. "today" meaning
whatever the date is when the macro is run. If the date in Y is more than 100
days from todays date, I need to hide the entire row.

Can anybody provide help with this?

Many thanks in advance!