Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I hide a ROW if cell value is zero in Excel
How do I hide a ROW if cell value is zero in Excel
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I hide a ROW if cell value is zero in Excel
Select the range of cells, then execute this macro:
Sub HideRows() Dim rn As Range Dim rng As Range Set rng = Selection For Each rn In rng.Cells If (rn.Value = 0 And rn.Value < "") Then Rows(rn.Row).Hidden = True End If Next End Sub -- Regards, Dave "wil4d" wrote: How do I hide a ROW if cell value is zero in Excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |