I want to check if a date in a cell is before the current date.
How can i do that (in VBA code)
![]()
Dim rng2 As Range, x As Range Set rng2 = Range("A14:M74") For Each x In rng2.Cells Select Case x Case "Daglige opgaver" lol = xlCenter xcolor = 15 bfont = True Case <date is before the current date>?? End Select x.Interior.ColorIndex = xcolor x.Font.Bold = bfont x.HorizontalAlignment = lol Next x End Sub
Bookmarks