Gurus,

I am looking to set a cell (K2) to todays date if cell (AE14) does not = 0, otherwise, I want cell (k2) to stay at its current date.

I have written the follow code in the Thisworkbook, but I don't know enough about VB to get it right. Please help.

Private Sub Workbook_Open()
    Worksheets("RFQ").Activate

    
    If Range(AE14).Value <> 0 Then
    Range(K2) = today()
    End If
    

End Sub
TIA,
Tim