Thread: Count values in Visible ROWS only
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randy Randy is offline
external usenet poster
  
Posts: 213
Default Count values in Visible ROWS only
I am looking for a way to count the values rows that are visible. I have rows
A14:A83 with values. Rows A39:A83 may be hidden at time. When these rows are
hidden is there a way to count the values in rows A14:A38 only, even if rows
A39:A83 still contain values?


--
Randy Street
Rancho Cucamonga, CA
Reply With QuoteReply With Quote