hi

When I select an option for a drop down list in B2, the date is automatically date/time stamped in cell C3. My problem is

1.) I need the date/time stamped in cell A2 instead.
2.) If there is no value in cell B2, the contents in cell A2 is to be cleared

Someone helpful provided me the following code in my worksheet

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("B2", "B10")) Is Nothing Then
Target.Offset(1,0).Value = Date & " - " & Time
End If

End Sub

I tried putting different values in Target.Offset but I don't seem to understand it. I tried doing the following below but it just doesn't work properly.

If Intersect(Target, Range("B2", "B10")) Is Nothing Then
Target.Offset(1,0).clearcontents
End If

Can someone show me what's wrong?

Thanks

Marlene