Thread: Need to know what is wrong with this 3 line code (row hiding with conditional formati
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Turquoise_dax[_6_] Turquoise_dax[_6_] is offline
external usenet poster
  
Posts: 1
Default Need to know what is wrong with this 3 line code (row hiding with conditional formati

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

Reply With QuoteReply With Quote