Hi,
I'm looking for a piece of code for hiding a non-contiguous set of rows in a Worksheet based on the value in column B being a formula blank (i.e. ="")
At the moment I have this, but it makes my Workbook grind to a halt:
I've seen autofilter used before, but the problem is that my range isn't contiguous.
Anyone got any bright ideas?
Thanks,
Matty
I'm looking for a piece of code for hiding a non-contiguous set of rows in a Worksheet based on the value in column B being a formula blank (i.e. ="")
At the moment I have this, but it makes my Workbook grind to a halt:
Code:
Sub HideBlankRows()
Application.ScreenUpdating = False
With Sheet8
.Calculate
For Each c In .Range("B7:B156, B165:B239, B244:B318, B323:B337, B342:B356")
c.EntireRow.Hidden = c.Value = ""
Next c
End With
Application.ScreenUpdating = True
End Sub
I've seen autofilter used before, but the problem is that my range isn't contiguous.
Anyone got any bright ideas?
Thanks,
Matty