Rows not hidden

[Starkers]

Hi Everyone

I have inserted a vba code to have the rows 17 to 25 hidden but it seems that row 25 was not hidden. Not sure what is the issue here..

If Range("C16") = "Malaysia" Then
    If Range("C7") = "Yes" Or Range("C7") = "No" Then
        Rows("17:25").EntireRow.Hidden = True
        
    Else
        Rows("17:25").EntireRow.Hidden = False
        
    End If

End If

 

[Peter_SSs]

have inserted a vba code to have the rows 17 to 25 hidden but it seems that row 25 was not hidden.

Then perhaps C16 is not Malaysia (case-sensitive) or C7 is not equal to Yes or No (both case-sensitive)?

What were the exact values of C16 and C7 when the code ran and what more is there to this code as we do not have all of it?

BTW, when you refer to rows as you have, Rows("17:25"), these are already entire rows so you don't need to specify EntireRow as well. This would do just as well

Rows("17:25").Hidden = True

 

[Starkers]

Then perhaps C16 is not Malaysia (case-sensitive) or C7 is not equal to Yes or No (both case-sensitive)?

What were the exact values of C16 and C7 when the code ran and what more is there to this code as we do not have all of it?

BTW, when you refer to rows as you have, Rows("17:25"), these are already entire rows so you don't need to specify EntireRow as well. This would do just as well

Rows("17:25").Hidden = True

went to look through the code and found that there was a conflicting criteria. thanks for the assistance anyway!

 

[Peter_SSs]

No problem. Glad you located the issue and thanks for letting us know.