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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.