I'm using the following Macro to hide zero rows over multiple columns and it's working great. I'm wondering what I can do to run this macro if some of the columns are blank, such as D, F, and G?
Sub HideRowsCtoBY()
Dim Last, i As Long
Application.ScreenUpdating = False
Last = Range("C:BY").Find(What:="*", After:=[C1], SearchDirection:=xlPrevious).Row
For i = Last To 1 Step -1
If Application.CountIf(Range("C" & i & ":BY" & i), "0") = 75 Then
Range("C" & i & ":BY" & i).EntireRow.Hidden = True
End If
Next i
Application.ScreenUpdating = True
End Sub
Thanks!
Bookmarks