Micros Button

[BABAR RASHEE]

Hi i want to make a button in my work sheet, which would help me to hide / unhide the rows with zero values and those unhide values should not print...Pls i need your prompt help to solve this issue.. As i am working on my P&L worksheet and i have to submitted latest by Tomorrow..
Thanks

babar

[Bob Phillips]

[vba]

Public Sub Test()
Dim cell As Range

For Each cell In Selection.Columns(1)

cell.EntireRow.Hidden = Application.CountA(cell.EntireRow) = 0
Next cell

End Sub
[/vba]

[BABAR RASHEE]

XLD

I didn't get you at all.... i am new in VBA just give me some detail steps to fix this

Thanks