Hi,
I am writing a code which will give me a message before 10 days of expiry in column I,
also the font of them will turn red,but I am getting error with code.also attaching the sheet.
Private Sub Workbook_Open() Dim Count As Long Count = Sheets("KolWB").Evaluate("COUNTIF(I:I,TODAY()-10)") If Count Then MsgBox "you have " & Count & " contracts expired" End Sub
Bookmarks