Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Rows based on value, but not using autofilter
Hi, I have seen a number of posts on this but still can't quite get
what I want. I have a sheet with maybe 20 rows at the top with statistics in, that I need to display. Then below here is my actual data. I have a column with from row 21 down with TRUE or FALSE in. On the click of a button I want to change the sheet so that all rows with FALSE in are hidden. I cant use autofilter as this also hides the rows at the top. I have a named range for the column which has TRUE or FALSE in, and so have the following code, but it does not work: Range("DisplayStart").Activate For Each c In Range("DisplayRange") If c.Value = "FALSE" Then c.Select c.EntireRow.Hidden = True End If Next Any ideas please? Cheers Rich |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Rows based on value, but not using autofilter
Are the TRUE and FALSE entries text or actual True/False values? If they are
actual True/False values and you are testing for the text "FALSE", the macro won't find any. Try this: Dim c As Range For Each c In Range("DisplayRange") If c.Value = False Then c.EntireRow.Hidden = True End If Next Hope this helps, Hutch "Richhall" wrote: Hi, I have seen a number of posts on this but still can't quite get what I want. I have a sheet with maybe 20 rows at the top with statistics in, that I need to display. Then below here is my actual data. I have a column with from row 21 down with TRUE or FALSE in. On the click of a button I want to change the sheet so that all rows with FALSE in are hidden. I cant use autofilter as this also hides the rows at the top. I have a named range for the column which has TRUE or FALSE in, and so have the following code, but it does not work: Range("DisplayStart").Activate For Each c In Range("DisplayRange") If c.Value = "FALSE" Then c.Select c.EntireRow.Hidden = True End If Next Any ideas please? Cheers Rich . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide & Show Rows based on Check Boxes | Excel Discussion (Misc queries) | |||
Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
Hide Rows based on value | Excel Discussion (Misc queries) | |||
hide rows based on cell value | New Users to Excel | |||
hide rows based on value in cell | Excel Discussion (Misc queries) |