Need to know what is wrong with this 3 line code (row hiding with conditional formati

[Turquoise_dax]

I wish for this macro to hide every rows whch contains "info" in colum
B, but when I push the button associated with it, all rows become
hidden. Any1 can help me with this?


ActiveSheet.Columns("B").Select
Selection.AutoFilter Field:=1, Criteria1:="info"
Selection.EntireRow.Hidden = Tru

 

[Die_Another_Day]

The rows that are filtered are still selected. Therefore when you hide
selection you hide everything. Try this:

Sub HideRows
Dim cell as range
for each cell in Range("B:B")
if cell = "info" then Rows(cell.row).Hidden = True
next
end sub

HTH

Die_Another_Day

 

[Turquoise_dax]

This works fine to hide. However, I also have a "show all" button and i
does not work after. Here is the (very short) code:

Rows("1:100").Select
Selection.EntireRow.Hidden = False

When clicking, it does not unhide rows previously hidden (and in th
range 1-100

 

[Die_Another_Day]

I'm not sure why that doesn't work. This seems to work for me:
Rows("1:100").Hidden = False

HTH

Die_Another_Day

 

[Turquoise_dax]

The row number are now all blue. What does it mean, and could it be
indicative of the problem?

 

[Die_Another_Day]

I think that means autoFiltering is still turned on.

Die_Another_Day