Hiding Rows if a Value is Zero

Originally Posted by Mordred

Hi johnnycanuck, the following code will hide rows with a 0 in them[code]Sub RowHider()
Dim wb As Workbook!

I have just tried this code and it nearly does what i require, however there are rows at the top and bottom of the work sheet that i don't want removing, is there a way for this to only run a group of rows i select?