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

  • Thread starter Thread starter Turquoise_dax
  • Start date Start date
T

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
 
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
 
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
 
I'm not sure why that doesn't work. This seems to work for me:
Rows("1:100").Hidden = False

HTH

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