Hi Preeti :: How are you doing?
This can be done using following code, click on the hyperlink. (little tweak required), Excel Macro VBA - Create a 12 Month Calendar With The Current Day Highlighted in Excel - Free Excel Macros VBA - TeachExcel.com
I am bit busy in some work, let me know if incase you are unable to change as per your need
Regards: A.S.




Reply With Quote
Bookmarks