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

--
Turquoise_da
-----------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...fo&userid=3518
View this thread: http://www.excelforum.com/showthread.php?threadid=55366

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 wrote:
I wish for this macro to hide every rows whch contains "info" in column
B, but when I push the button associated with it, all rows becomes
hidden. Any1 can help me with this?


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


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553660

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

--
Turquoise_da
-----------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...fo&userid=3518
View this thread: http://www.excelforum.com/showthread.php?threadid=55366

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 wrote:
This works fine to hide. However, I also have a "show all" button and it
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 the
range 1-100)


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553660

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


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553660

I think that means autoFiltering is still turned on.

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


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=553660