Hi,

I have added a few new rows and now I can't get it to work.

These are the conditions:

If all cells with the 6 X are empty = hide row 150-152
If J151 or P151 have any value = keep row and also keep row 150
If J152 or P152 have any value = keep row and also keep row 150
If only row 150 has values = hide row 151 and 152

Capture.PNG

Formula: copy to clipboard


Sub Skjul_0_Projektaftale()

beginRow = 150 'first row'
endRow = 180 'last row'
CheckCol_1 = 4 'column number --> Gulvarme
CheckCol_2 = 10 'First column
CheckCol_3 = 16 'Second column

For rowNum = beginRow To endRow
If Cells(rowNum, CheckCol_1).Value <> "" And Cells(rowNum + 1, CheckCol_2).Value = 0 And Cells(rowNum + 1, CheckCol_3).Value = 0 Then
Cells(rowNum + 2, CheckCol_1).EntireRow.Hidden = True

End If
Next rowNum

For rowNum = beginRow To endRow
If Cells(rowNum, CheckCol_1).Value <> "" And Cells(rowNum, CheckCol_2).Value = 0 And Cells(rowNum, CheckCol_3).Value = 0 _
And Cells(rowNum + 1, CheckCol_2).Value = 0 And Cells(rowNum + 1, CheckCol_3).Value = 0 Then
Cells(rowNum, CheckCol_1).EntireRow.Hidden = True

End If
Next rowNum


End Sub