Hide macro
I want to use a macro that will hide rows in the range of 17 to 61 where a value in column B is 0 on a protected sheet. This has to be automatic (multi-user friendly) rather than using advanced filtering.
Software/Hardware used:
Excel 2007 Vista
Software/Hardware used:
Excel 2007 Vista
ASKED:
February 11, 2010 5:58 PM
UPDATED:
March 16, 2010 1:47 PM
Answer Wiki:
You can use this one. You can select whatever range you want.
.....................................................................................................................
Sub hidingrows()
Dim i As Integer
Dim m As Integer
Dim h As Integer
Sheets("sheet2").Select
Range("a4").Select
m = Range(Selection, Selection.End(xlDown)).Count
h = 0
For i = 1 To m
Range("a4").Offset(h, 0).Select
If Selection.Value = 0 Then
Selection.EntireRow.Hidden = True
End If
h = h + 1
Next
End Sub
...........................................................................................................................
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
