hide row automatically
 

i have filed like

Date, party name, amt,
startdt,proddt,proccdt,finesdt,dispdt,

i want when i fill data in all last 5 filed it should
automatically hide that row.

how to do that? any help plz.
Thanks in advance.

hide row automatically
 

Right click on the sheet tab and select view code. Paste in code similar to
this:


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Application.CountA(cells(Target.Row,4).Resize(,5)) = 5 Then
Target.EntireRow.Hidden = True
End If
End Sub

Regards,
Tom Ogilvy


****al wrote in message
...
i have filed like

Date, party name, amt,
startdt,proddt,proccdt,finesdt,dispdt,

i want when i fill data in all last 5 filed it should
automatically hide that row.

how to do that? any help plz.
Thanks in advance.