This is not working... I guess it has everything to do with another
problem I have: I programmed a button to hide rows with a cetain info,
but the other button supposed to show all is not working after I
switched to summary view.

here is the codes (very short!)

Summary view:
Dim cell As Range
For Each cell In Range("B:B")
If cell = "i" Then Rows(cell.Row).Hidden = True
Next

Complete View:
Rows("1:100").Hidden = False

and the "select all" then "unhide row" is not working either. My row
numbers are now all blue. Any1 know what is the problem?

Thx


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