Re: $$Excel-Macros$$ Subtotal for visible/unhidden column

2014-07-09 Thread Vaibhav Joshi
pl share sheet with example.. Cheers!! On Wed, Jul 9, 2014 at 12:17 PM, Rajeev rajeevk...@gmail.com wrote: Dear Group, We use subtotal for row now I like to following please help if it is possible: - 1 In one worksheet i am using Column A1 to EL82 2

RE: $$Excel-Macros$$ Subtotal for visible/unhidden column

2014-07-09 Thread Rajeev
PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vaibhav Joshi Sent: 09 July 2014 12:25 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Subtotal for visible/unhidden column pl share sheet with example.. Cheers!! On Wed

Re: $$Excel-Macros$$ Subtotal for visible/unhidden column

2014-07-09 Thread Vaibhav Joshi
Of *Vaibhav Joshi *Sent:* 09 July 2014 12:25 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Subtotal for visible/unhidden column pl share sheet with example.. Cheers!! On Wed, Jul 9, 2014 at 12:17 PM, Rajeev rajeevk...@gmail.com wrote: Dear Group, We use

RE: $$Excel-Macros$$ Subtotal for visible/unhidden column

2014-07-09 Thread Rajeev
: 09 July 2014 13:18 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Subtotal for visible/unhidden column Check Col L, you need to use UDF as mentioned in it. Calculate sheet by pressing F9 once you hide / unhide cells. Cheers!! On Wed, Jul 9, 2014 at 12:38 PM, Rajeev