Excel hide row if 0

[lous]

I'm looking for an Excel macro that will look at a column of numbers and if the number is 0 in that column, it will hide that row (record) from view.

Any ideas?

 

[xlhelp]

Highlight the data in the column
and run the following macro

Sub hidrow()
Dim currentcell As Object
For Each currentcell In Selection
If currentcell.Value = 0 Then
currentcell.EntireRow.Hidden = True
End If
Next currentcell

End Sub

HNY

 

[VulcanJedi]

Using the default AUTOFILTER in XL would be much easier/faster...Find it in the menu bar. Tranpkp