macro function

For RowCnt = BeginRow To EndRow

If Cells(RowCnt, 3).Value = 0 And Cells(RowCnt, 4).Value = 0 And Cells(RowCnt, 5).Value = 0 And Cells(RowCnt, 6).Value = 0 And Cells(RowCnt, 7).Value = 0 Then

Cells(RowCnt, ChkCol).EntireRow.Hidden = True

End If

 

 

 

 

says there is an error in the if line

By: eli aporn

Leave a Reply

Your email address will not be published. Required fields are marked *