Macro to hide empty row with a certain range

[pincivma]

Hello again

I'm trying to do a macro that hides the entire row but with the specification of a certain range. I tried the following code but I got an error. Please help

If Range("E15:GC15") = "" Then
Selection.entireRow.Hidden = False.

Thank You

 

[rpaulson]

so you want to hide row 15 if EVERY cell from column E Thru column GC is blank?

 

[pincivma]

That is correct

 

[rpaulson]

THis will hide them if blank and unhide if not blank

If (WorksheetFunction.CountIf(Range("E15:GC15"), "<>" & "")) = 0 Then Rows(15).EntireRow.Hidden = True Else Rows(15).EntireRow.Hidden = False

 

[pincivma]

Hi rpaulson

Thanks for the line of code. It works GREAT!!!