View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default For Each with Hidden Rows

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