Hi everyone... I have a problem with a macro that I'm trying to put together... I currently have a copy - paste value macro that I use to break circularities which works fine but I want this additional Save/Close macro to work after a certain date and delete certain cells and then save/close the Excel file... Kind of like an expiration date for the workbook...
The code I have is...
If Range("Today_date") < Range("Valid_date") Then Application.DisplayAlerts = False
With ThisWorkbook
.Save
.Close
End With
Application.DisplayAlerts = True
This saves and closes the file whether Today_date is larger or smaller than Valid_date and skips the copy - paste macro... Will appreciate all the help I can get...
Thank you in advance...
Bookmarks