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

T

Turquoise_dax

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

Paul B

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" <[email protected]>
wrote in message
news:[email protected]...
 
T

Turquoise_dax

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
 
Top