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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks