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-