PDA

View Full Version : Micros Button



BABAR RASHEE
02-17-2008, 05:46 AM
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
02-17-2008, 08:07 AM
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

BABAR RASHEE
02-17-2008, 01:09 PM
XLD

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

Thanks