View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Subtotal Function

Hi

No built in function but look at the workaround produced by Debar
Dalgleish
http://www.contextures.com/HideMarkedCols.zip

--
Regards

Roger Govier


"lindsayhyle" wrote in message
...
I understand the "Subtotal" function only ignores hidden data in rows.
Is
there a similar function that will ignore hidden data in columns?
Thanks.