Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Rows in EXCEL (Conditionally)
Darran
Sub Hide_Zeros_Rows() 'using set column Dim RngCol As Range Dim i As Range Set RngCol = Range("B1", Range("B" & Rows.Count). _ End(xlUp).Address) For Each i In RngCol If i.Value = "0" Then _ i.EntireRow.Hidden = True Next i End Sub Hides rows if value is 0 in Column B. Gord Dibben Excel MVP XL2002 On 13 Sep 2003 18:38:55 -0700, (Darran Caputo) wrote: Is there a way to hide rows in a worksheet based on a value in the row? In other words: IF A1 0 then "Hide Row" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error 1004 while conditionally hiding rows as a result ofworksheet protection | Excel Discussion (Misc queries) | |||
conditionally hiding rows | Excel Discussion (Misc queries) | |||
Conditionally Hiding Rows | Excel Discussion (Misc queries) | |||
Hiding Rows Conditionally | Excel Discussion (Misc queries) | |||
Conditionally Hiding Rows | Excel Programming |