Hello,

I was wondering if I could get help to write a query for the scenario
whe

I enter a value in column A and a date appears in column B, which
stays fixed and does not change based on the current date. Also, if I
delete the value from Column A, then the date also gets deleted.

This is what I have so far:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 1 Then
Target.Offset(0, 1).Value = Now()
End If
End Sub

The problem is, as I said, if I delete the value from column A, the
date still stays in column B, which I don't want it to.

Any help will be great.

Thanks very much!