View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eva Shanley Eva Shanley is offline
external usenet poster
 
Posts: 2
Default Leave hidden rows out of sum

Is there a way, either programmatically or with a User
Defined function, to leave hidden rows out of a sum? A
user here wants to hide rows in various instances without
having to redefine the sum range all the time, and does
not want them included in his total. Any help as always
is appreciated!