SHG - You were able to help me last time with this code, I'd appreciate it if you could lend me your expertise one more time.![]()
Please Login or Register to view this content.
The code works however I noticed that my date wasn't changing. After looking at the code I realized why. The line "If IsEmpty(.Value) Then .Value = Date" will only generate a new date if the cell is empty. How do I amend the code so that the current date is generated when the workbook opens, regardless of whether or not there is data in the cell?
Bookmarks