Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unhide all rows without loop
Worksheets("Sludge").Rows.Hidden = False -- Jim Cone Portland, Oregon USA "Saladin Andreas" wrote in message using "hide rows" instead of autofilter (which works not so well) gives a problem if you wanna see all rows again. How can you do that without looping trough all possible rows (given that you don't know whether there are 100 or 30'000). How can you find out about how many rows there are (if you have to do it with a loop you should not loop endlessly) When hiding it is easy to leave the loop when empty rows occur. -snip- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow VBA code....Hide/Unhide Loop | Excel Worksheet Functions | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
unhide row does not unhide the hidden rows | Excel Worksheet Functions | |||
Hide Rows (Current Date) / Unhide Rows | Excel Programming | |||
Loop through worksheets to unhide rows | Excel Programming |