View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tod[_3_] Tod[_3_] is offline
external usenet poster
 
Posts: 17
Default For Each with Hidden Rows

Oops. It wasn't that the loop was skipping hidden rows.
It was that my statement for finding the last row was
flawed.

So as Emily Litella would say....

Never Mind


-----Original Message-----
My worksheet has hidden rows. Which rows are hidden is
not known at run time. I want to do a For Each... loop
that cycles through a range of cells in a column.

However
I've noticed that the loop ignores cells in hidden rows.
Is there a way to cycle through a range that includes
hidden rows?

tod
.