I have a spreadsheet used for managing dates and deadlines where Column K is for DUE DATE, M for EXPIRY DATE, P for RENEWAL DATE.

What I would like is to have a macro which runs automatically on launch to print a range called "reminder" if DUE DATE has passed today's date. The macro should check all cells in the Column K and then its should start from column M and print a range called "reminder1" if EXPIRY DATE has passed today's date. The macro should check all cells in the Column M and then its should start from column P and print a range called "reminder2" if RENEWAL DATE has passed today's date.


Any help would be most appreciated!

Thanks,


EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx