View Single Post
 
Old 03-06-2021, 11:07 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Please add example workbooks to save us wasting time recreating them

The below should work as a stand alone Macro, not done it as selection change

Code:
Sub CheckDate()

    Dim TheDate As Date
    
    TheDate = Date
    
    If ActiveCell.Value = "" And ActiveCell.Offset(-1, 0) = TheDate Then
        Range("A" & ActiveCell.Row) = TheDate
        
    End If

End Sub
Reply With Quote