OK...I see now. I clicked the Design button then enabled macros and reopened
the file. Super.

Now I am getting Run-time error '1004'.
Application-defined or object-defined error

Again...I just know I am doing something mind-numbingly stupid. Excel code
is just beyond me. TIA

"Geoff" wrote:

OK...I'm confused.

I added the following to the code for the sheet (right-clicked the tab and
selected View Code):

Private Sub Worksheet_Change(ByVal Target As Range)

If Target = Range("G4") Then
Range("G5").Value = Now
End If

If Target = Range("H4") Then
Range(H5).Value = Now
End If

End Sub

Right away, it worked like a charm. I saved the file and I was told I needed
to save as a macro-enable workbook. No problem. Easy peasy.

I reopened the macro-enable workbook and now it doesn't work. I change the
data in either G4 or H4 and nothing happens. So I opened the code sheet.
Nothing seems amiss. So I put a breakpoint in on the first IF statement and
nothing happens when I change the data.

I just know I am doing something so mind-numbingly stupid. TIA