hide row automatically

  • Thread starter Thread starter shital
  • Start date Start date
S

shital

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.
 
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
 
Back
Top