I have a simple worksheet of jobs I need to do. Just 3 columns, and when I
put a date in column 3 I would like the row to be hidden immediately
(because the job is finished).

Any suggestions would be appreciated.

Hi Brian,

You could adapt something along these lines :

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
Set Target = Range("C2:C20")
If Target Is Nothing Then
Exit Sub
Else
For Each Cell In Target
If Cell.Value < "" Then
Cell.Offset(0, 0).EntireRow.Hidden = True
End If
Next Cell
End If
End Sub

HTH
Cheers
Carim

Hi Brian,

Something like this should do what you want:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
If IsDate(Target.Value) Then Target.EntireRow.Hidden = True
End If
End Sub

Regards,
GS