Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

HI kuldeep, Please Ingnor previous mail That is incomplete. Please find attachment. On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh wrote: > Thanks Chaya. > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 > naukrikuld...@gmail

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

Hi Kuldeep, You can also use this formula. =REPLACE(TRANSPOSE(sheetnames),1,FIND("]",TRANSPOSE(sheetnames),1),"") Regards Priti verma On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh wrote: > Thanks Chaya. > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > Phone.: +91-0120-48411

Re: $$Excel-Macros$$ macro for pivot

Dear Sagar, Can u specify more what u want excatly. Warm Regards, Gawli Anil N On Fri, Apr 26, 2013 at 11:50 AM, sagaraher wrote: > Hello Anil, > > You have helped me last time to create different sheets & mail against > given mail-id through macro. I have one more data sheet to which I need

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

Dear Vijay sir and All experts, Thank you so much for sharing the Addin. Thank you all for guiding and helping me in learning excel with VBA. Regards, Chaya On Fri, Apr 26, 2013 at 10:52 AM, P.VIJAYKUMAR wrote: > Respected Chaya, > > There is also an add-in called "Ultimate add-in

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

Respected Chaya, There is also an add-in called "Ultimate add-in",Which has features like sort sheets and a lot of very useful features.It is available for 2007 and earlier excel version also.Please find the attachment and install the add-in. Regards, Vijaykumar SetUp2007.exe

$$Excel-Macros$$ Animate an Excel Chart in PowerPoint

Click the link below for full tutorial. http://rajexcel.blogspot.com/2013/01/animate-excel-chart-in-powerpoint.html#.UXoAQKJTCiw you can find the how to 1-Create Separate Animations Within the PowerPoint Chart 2-Focus on Different Parts of the PowerPoint Chart 3-Open the PowerPoint An

Re: $$Excel-Macros$$ Re: copy formula down

try this Sub reset() Dim Lrow As Long lastrow = Range("C" & Rows.Count).End(xlUp).Row Range("a3:d" & lastrow).Clear Range("c2:d2").Clear End Sub Sub applyformula() Dim Lrow As Long lastrow = Range("C" & Rows.Count).End(xlUp).Row Range("A2:B" & lastrow).FillDown End Sub On Fri, Apr 26, 2

$$Excel-Macros$$ Re: copy formula down

Thank you for the tip. Moving to cell A3 works, except when my only data is in C3 & D3. My goal is to reset the worksheet without the users losing the formulas. On Wednesday, April 24, 2013 8:10:58 PM UTC-4, David H wrote: > > > > I am using an excel spreadsheet in conjunction with Loftware. wh

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

Hi chaya Thanks to provided me this pfa of noorain sir. Thanks Priti verma On Thu, Apr 25, 2013 at 9:18 PM, Kuldeep Singh wrote: > > Hi Preety, > > PFA Get Function by Noorain Sir. I hope it will help you. > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > Phone.: +91-0120-48

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

Hi chaya actually i am not getting Get.workbook how you use Get.workbook have you written any code for that or it is a function in other version of excel On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh wrote: > Thanks Chaya. > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) >

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

Hi Chaya, Please can you explane it that u use in your sheet. =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"") Regards, Priti verma On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh wrote: > Thanks Chaya. > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > Phone.: +91-0120

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

Thanks Chaya. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Fri, Apr 12, 2013 at 12:55 PM, Ch

Re: $$Excel-Macros$$ copy formula down

Though i am not sure but try this Change A2 to A3 in below line Range("A2").Select in the macro Sub close_sheet() ' ' close_sheet Macro ' ' Range("A3").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.ClearContent

Re: $$Excel-Macros$$ copy formula down

Dave, you might want to explain that a bit. Not exactly sure what you are saying. On Thu, Apr 25, 2013 at 5:40 AM, David H wrote: > > > I am using an excel spreadsheet in conjunction with Loftware. which > requires headers in cells A1 and B1. I have formulas in A2 and B2 > calculating data fr