gazingdown
Board Regular
- Joined
- May 21, 2003
- Messages
- 109
I have a row where all cells are dates. I need to be able to select the cell that has the maximum date before today.
Say I ran the report today, in my sheet there tends to be a column for each week and the date in each column tends to be a monday(but not always) and I would want to select the cell with the date 8th March 2004
This is to be done in VBA.
Say I ran the report today, in my sheet there tends to be a column for each week and the date in each column tends to be a monday(but not always) and I would want to select the cell with the date 8th March 2004
This is to be done in VBA.