A
AMcB
I have a similar problem to a below post with the same title but instead it being about an entire column, I'm trying to hide the zero values in just a range of cells. I've been trying to get the below macro to work but it's just not happening for me. Can anyone suggest the necessary changes? The Macro is to hide zero values in column 6, rows 13 to 70.
Sub hide_rows()
For rwIndex = 13 To 70
For colIndex = 6 To 6
With Worksheets("UCS").Cells(rwIndex, colIndex)
If .Value = 0 Then EntireRow.Hidden = True
End With
Next colIndex
Next rwIndex
End Sub
Thanks for any advice you can give.
I know Autofilter can do a similar job but I'd like to get this to work.
Cheers,
AMcB
Sub hide_rows()
For rwIndex = 13 To 70
For colIndex = 6 To 6
With Worksheets("UCS").Cells(rwIndex, colIndex)
If .Value = 0 Then EntireRow.Hidden = True
End With
Next colIndex
Next rwIndex
End Sub
Thanks for any advice you can give.
I know Autofilter can do a similar job but I'd like to get this to work.
Cheers,
AMcB