Hide Entire Rows Range
Hi At the moment I have this code to hide entire row
and it is working fine.
Sub HideRows()
Dim MyRange As Range, cl As Range
Set MyRange = Sheet3.Range("A23:IV25")
Application.ScreenUpdating = False
For Each cl In MyRange
If cl.Value < "Minimum" Then cl.EntireRow.Hidden = True
Next cl
Application.ScreenUpdating = True
End Sub
Now another question is
How can I hide the Entire Range("A23:IV25") if the Value is "Minimum"?
Thanks
|