Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding Rows using conditions
Is it possible to hide a row based upon a value one of the columns?
Thank you. Jeff R. |
#2
|
|||
|
|||
Jeff
You may get away with a filter, either auto or advanced to hide rows. Or you may need VBA code, either event or menu/button driven. Sub Hide_Rows() 'using set column A Dim RngCol As Range Dim i As Range Set RngCol = Range("A1", Range("A" & Rows.Count). _ End(xlUp).Address) For Each i In RngCol If i.Value = "yours" Then _ i.EntireRow.Hidden = True Next i End Sub In any case, if you're wondering, hiding a row is not a feature of Conditional Formatting. Gord Dibben Excel MVP On Mon, 15 Aug 2005 15:33:03 -0700, Looney wrote: Is it possible to hide a row based upon a value one of the columns? Thank you. Jeff R. |
#3
|
|||
|
|||
Only with VBA? Is that okay If so, give some details.
-- HTH RP (remove nothere from the email address if mailing direct) "Looney" wrote in message ... Is it possible to hide a row based upon a value one of the columns? Thank you. Jeff R. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
Hiding of rows and columns | Excel Discussion (Misc queries) | |||
HIDING ROWS IN PROTECTED WORKSHEETS | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |