$$Excel-Macros$$ Re: sub

2009-10-01 Thread Dilip Pandey
Thanks Subbu, Little correction in the last three steps:- press up arrow and type " sum" press Ctrl + Enter done Above should only be followed after you have done Subtotal for entire data set. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.co

$$Excel-Macros$$ Re: sub

2009-10-01 Thread Dilip Pandey
Hi Subbu, Two solutions:- 1) continue using subtotal but at the end do the trick as explained in the attachment in sheet "option 1" 2) Do pivot table Thanks, Dilip Kumar Pandey Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@

$$Excel-Macros$$ Re: Sub not visible

2009-02-17 Thread saravanan c
I doubt whether you have defined the Sub procedure as Private. If so remove the Private key word. C.Saravanan On Thu, Nov 20, 2008 at 9:16 PM, macrogirl wrote: > > I have a sub procedure written under another procedure. When I press > F5 to run the procedure, it is not listed in the drop down me

$$Excel-Macros$$ Re: Sub not visible

2008-11-21 Thread Tom Jeffries
Could you post the file in question? Tom On Thu, Nov 20, 2008 at 10:46 AM, macrogirl <[EMAIL PROTECTED]>wrote: > > I have a sub procedure written under another procedure. When I press > F5 to run the procedure, it is not listed in the drop down menu but > the code right above it is. Any suggestio