How to view when all is hidden... (Feeling stoopid)
 

After an unsuccessful program, all rows got hidden in my sheet. How do I
get them back? (w/o 65 000 successive drag of rows:P)


--
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

How to view when all is hidden... (Feeling stoopid)
 

press Ctrl+A
then press Ctrl+Shift+(

hope this would work.


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

How to view when all is hidden... (Feeling stoopid)
 

Turquoise, try Ctrl+A then format, rows, unhide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Turquoise_dax"
wrote in message
news:Turquoise_dax.29pibb_1150816802.2897@excelfor um-nospam.com...

After an unsuccessful program, all rows got hidden in my sheet. How do I
get them back? (w/o 65 000 successive drag of rows:P)


--
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

How to view when all is hidden... (Feeling stoopid)
 

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