Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
Hi gurumurthy, i dont think he means what u said. he means lets say we write =sum(A1+A2) in excel cell you will see some info for sum function which is provided by microsoft itself. but if we have developed our own function (lets say ofunct) and we type this function in any cell like =ofunct() then e shud see the same kind of info as we see for miscrosoft functions. @Rajesh please correct me if i m wrong. From: gurumurthy sastry Kondury gurumurthy.sas...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, 4 January, 2011 10:31:34 AM Subject: Re: $$Excel-Macros$$ Description while using Macro Functions in Excel Hi Rajesh, If your question is to use the function in one Cell ( Say B1) and to show the description of the Function in the next cell ( say C1) , then use your function in Cell B1, and put the same function in Cell C1 leaving one space. See Example below =IF(logical_test, value_if_true, value_if_false) This is how you normally put the function. =IF(logical_test, value_if_true, value_if_false) Here you leave a space in Cell C1 and here its just a text but not the function. Hope this helps. Or correct me If my understanding is wrong. Best Regards, Haigreeva On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Hi, Dilip Congratulations for the great success.. Sanjay On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Best Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
hi gurumurthy, you are right. I want to see the description in our macro function as we see for microsoft functions. hi Haigreeva, as per the comments by the gurumurthy, I want to see the description in our macro function as we see for microsoft functions. hi Kiran, i am using Excel 2007 version. Thanks On Tue, Jan 4, 2011 at 12:43 PM, hanumant shinde hanumant_5...@yahoo.co.inwrote: Hi gurumurthy, i dont think he means what u said. he means lets say we write =sum(A1+A2) in excel cell you will see some info for sum function which is provided by microsoft itself. but if we have developed our own function (lets say ofunct) and we type this function in any cell like =ofunct() then e shud see the same kind of info as we see for miscrosoft functions. @Rajesh please correct me if i m wrong. -- *From:* gurumurthy sastry Kondury gurumurthy.sas...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, 4 January, 2011 10:31:34 AM *Subject:* Re: $$Excel-Macros$$ Description while using Macro Functions in Excel Hi Rajesh, If your question is to use the function in one Cell ( Say B1) and to show the description of the Function in the next cell ( say C1) , then use your function in Cell B1, and put the same function in Cell C1 leaving one space. See Example below =IF(logical_test, value_if_true, value_if_false) This is how you normally put the function. =IF(logical_test, value_if_true, value_if_false) Here you leave a space in Cell C1 and here its just a text but not the function. Hope this helps. Or correct me If my understanding is wrong. Best Regards, Haigreeva On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.comwrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Urgent help Required
pl stop this On Tue, Jan 4, 2011 at 2:07 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Tue, Jan 4, 2011 at 11:58 AM, Born to Win cs4...@gmail.com wrote: Hi Friends, Please help me to Apply sum Average Formula at the end of Month however when i am taking more than 30 Arguments i am getting an error. Thanks, Chandrabhan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Sujeet -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Urgent help Required
Dear Ashish Ji, i hv a question, i am looking your attachment where u r using an array formula and the average col. many of cells is empty where the no. of calls having value (1 or 2) is it ok? or the calculating method of mine for average is correct. please clear me, or suggest me if my working is worng. Thanks Regards ROHAN 9818247278, 8860567680 On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, Please find the attachment Thanks Regards ROHAN 9818247278, 8860567680 On Tue, Jan 4, 2011 at 2:10 PM, ashish koul koul.ash...@gmail.com wrote: ignore the previous mail check this one On Tue, Jan 4, 2011 at 2:07 PM, ashish koul koul.ash...@gmail.comwrote: check the attachment see if it helps On Tue, Jan 4, 2011 at 11:58 AM, Born to Win cs4...@gmail.com wrote: Hi Friends, Please help me to Apply sum Average Formula at the end of Month however when i am taking more than 30 Arguments i am getting an error. Thanks, Chandrabhan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Urgent help Required
Thanks u So much Experts. Thanks, Chandrabhan Singh On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, Please find the attachment Thanks Regards ROHAN 9818247278, 8860567680 On Tue, Jan 4, 2011 at 2:10 PM, ashish koul koul.ash...@gmail.com wrote: ignore the previous mail check this one On Tue, Jan 4, 2011 at 2:07 PM, ashish koul koul.ash...@gmail.comwrote: check the attachment see if it helps On Tue, Jan 4, 2011 at 11:58 AM, Born to Win cs4...@gmail.com wrote: Hi Friends, Please help me to Apply sum Average Formula at the end of Month however when i am taking more than 30 Arguments i am getting an error. Thanks, Chandrabhan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Hi Dilip Sir, Congratulations to you . That is good news on new year 2011. sharad gupta On Mon, Jan 3, 2011 at 7:32 PM, Manoj kumar manoj.vishwakarma...@gmail.comwrote: Congrats Dilip... Best Regards, Manoj Kumar On Mon, Jan 3, 2011 at 8:50 AM, ashish koul koul.ash...@gmail.com wrote: congrats dilip On Mon, Jan 3, 2011 at 4:48 PM, vidyut more vidyutm...@gmail.com wrote: hi Dilip ji Congratulations to you and Hatsoff u On Mon, Jan 3, 2011 at 3:35 PM, bhavya khanna bhavya...@gmail.comwrote: Hi Dilip Sir, Congratulations to you . That is good news on new year 2011. and where is treat ? On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and
Re: $$Excel-Macros$$ Need urgent help!
Dear Sharma, I have no idea of your requirement but the file seems to be like willing to know the password predictions algorithms. Or Hacking password techniques. Please clarify on this or correct me if i failed to understand your file. Thanks Regards Ahmed Bawazir On Mon, Jan 3, 2011 at 11:14 AM, amrahs k amrahs...@gmail.com wrote: Hi Ayush and Team, Happy new year to all members in our group! I have listed my query in the attached sample file. Kindly help me to determine the same. Thanks, Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ skewness Kertosis
See attachement On Mon, Jan 3, 2011 at 10:30 PM, Kenil Gala keni...@yahoo.com wrote: Hi group, i want to draw a graph for skewness and kertosis for some random numbers, but i am unable to it. could anyone help me out with problem?.i am little weak in this.The random nos are: 944.1 892.3 948.75 947.05 1000.65 984.4 980 1011.6 998.1 996 1060.35 1101.85 1134.5 1157.6 Hoping for reply. Thanks Regards, Kenil Gala -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Graph.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Problem in Data Validation in Excel
Hi All, I have a question related to data validation in excel. Below is the description.. I want to create two dropdown list using the data validation list. one is for countries and other is for State of the countries. My question is if i select country from first dropdown thee second dropdown populate only the state of India country. -- *Thanks and Regards,* Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Congrats Dilip On Tue, Jan 4, 2011 at 7:37 PM, sharad gupta sharadgupta2...@gmail.comwrote: Hi Dilip Sir, Congratulations to you . That is good news on new year 2011. sharad gupta On Mon, Jan 3, 2011 at 7:32 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Congrats Dilip... Best Regards, Manoj Kumar On Mon, Jan 3, 2011 at 8:50 AM, ashish koul koul.ash...@gmail.comwrote: congrats dilip On Mon, Jan 3, 2011 at 4:48 PM, vidyut more vidyutm...@gmail.comwrote: hi Dilip ji Congratulations to you and Hatsoff u On Mon, Jan 3, 2011 at 3:35 PM, bhavya khanna bhavya...@gmail.comwrote: Hi Dilip Sir, Congratulations to you . That is good news on new year 2011. and where is treat ? On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts --
$$Excel-Macros$$ Submit your Excel Idea Suggestion now
Dear group, I have initiated a series to collect your 'out of the box' ideas and suggestions on Microsoft Excel. The idea can be new feature, functionality, bug fixing, suggestion, or any new thing you want to view in excel. Till now, Only 33 ideas are submitted and 86 votes have supported them. The objective is to collect at least 1000 ideas and you can support this initiative by submitting an Idea. There is a prize of $10 for top 5 ideas. You can submit as many ideas you have. You can also vote the ideas which is submitted by others. The link to submit idea is :- http://goo.gl/mod/psLh Anyone can submit idea i.e. your friends, colleagues, boss , relatives and you. ;) Best Regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Need help with text alignment in VBA string
I am hoping someone can help me out with a problem that I am having. I have a macro that I am working on in Excel 2003 right now that takes multiple fields from a spreadsheet and makes a text string. It was working great, until I had to add a few fields that were deemed necessary to have. I have two fields in the spreadsheet that contain text, never more than 4 characters long, and I need them to take up 6 spaces in my text string. I got this to work using the following: StrOut = StrOut StrDelim Format(Cells(R, 33).Value, @@) StrOut = StrOut StrDelim StrOut = StrOut StrDelim Format(Cells(R, 34).Value, @@) StrOut = StrOut StrDelim While the bit of code above gives me the correct number of spaces, 6, the text is aligned on the right. I need to find out how to get the alignment on the left. Right now I have a ton of data not importing correctly because the system is specifically looking for these two bits of text to start on the right side. What can I do to get these left justified without having to do a ton of modifications to my existing code, since this is only a small portion of the string that is being written? Thanks for the assistance!! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Method 'Calculation' of object '_Application' failed
Getting this error when trying to execute the following statement in Auto_Open macro: Application.Calculation = xlCalculationAutomatic We have a group of Excel templates where the Workbook is password protected, as well as some sheets that are protected. We also use .xlam file that contains some macros that are called once the Excel document is opened. Any ideas of setting the Caluclation to Automatic without getting this error message Thanks, Charles -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Method 'Calculation' of object '_Application' failed
Dear Excel User, Move your code to module and then call it in Auto_Open or Workbook_Open. ___ Thanks Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ___ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ How to use 'Custom' Format for Numbers, Dates and Text in Excel?
Hi Friends, *What is 'Custom Format' ?:* Microsoft Office Excel provides many built-in number formats, but in some cases they do not meet our needs, we can customize a built-in number format to create our own. *Why 'Custom Format' and not 'Conditional Formatting'?:* because to cure 'Common Cold' we go to doctors not surgeons. Exactly, when there is a simple and robust way then why to go otherwise. There are many benefits of using custom format including these: 1. Less overhead than Conditional Formatting. 2. Values can be used easily in formulas (Less manipulation required). 3. Charts looks better with custom colored labels/axis. 4. Works on all versions of Excel. and many more which you can figure out using your innovative mind after reading this article. Do you know how to use 'Custom' format in Excelhttp://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html, if yes then solve these 5 questions on 'Custom' format ... * COMMENTS * *TO DISPLAY* * AS * * USE WHICH CUSTOM FORMAT* Negative Number -123000 (123K) ? Date 26/05/1984 Sat, May '84 Currency 6.56 £7 Labels 25 25 feet Round off to 100th 987654321 988 If you don't know much about 'Custom' format then learn here. Hope you'll enjoy it :)http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html __ Thanks Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com __ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Fwd: $$Excel-Macros$$ Custom UDF
Can any one answer the below or only simple questions are answered here just to become MVP -- Forwarded message -- From: Anju anjulav...@gmail.com Date: Mon, Jan 3, 2011 at 12:44 PM Subject: $$Excel-Macros$$ Custom UDF To: excel-macros@googlegroups.com Hi Team, Can anyone give me a Custom UDF which changes the cells back ground color. I have read that UDF cannot change the physical characteristic of a cell...but are there any exceptions. Please Help Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Custom UDF
Dear Anju, Hope you are doing well Happy New Year !! For your information, The functions return values and not formats. Hence No custom UDF can change physical characteristic of a cell. If you want to change the color of cell , Then use conditional formatting. I hope it answers your question let me know if you need any further information. Answer of your second question :- only simple questions are answered here just to become MVP This group is setup with the objective of free sharing of knowledge learn by helping others. People come here when they have time and solve queries without any expectation in return. In this group, Do not come with any higher expectations because this is not paid service. It takes lot of efforts time in solving any query. The group members try and give their best in solving queries. After all, This is the biggest Google group of excel. Becoming MVP is not solving simple queries but about consistently sharing your knowledge through various channels, take initiatives learn technology with passion. Visit below link to know more about becoming an MVP. http://mvp.support.microsoft.com/gp/mvpbecoming I was happy to hear this open comment from you. Let me know if you need any further clarification *Dear Group, Feel free to comment share your opinion about this group. This is your own group.* Best Regards Ayush Jain Group Manager Microsoft MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Problem in Data Validation in Excel
hi Jitendra, First, Define the name range of the countries as Country Second, Define the name range of states as Country Name e.g. For all indian states give name range India Third, In first column use data validation of country in Second column use this formulat in Data Validation in List as =INDIRECT(SELECT THE CELL OF PREVIOUS COLUMN WHERE YOU HAVE USED COUNTRY) If you have further problem, kindly view the attachment. On Tue, Jan 4, 2011 at 8:45 PM, Jitendra Verma jitendra.kumarve...@gmail.com wrote: Hi All, I have a question related to data validation in excel. Below is the description.. I want to create two dropdown list using the data validation list. one is for countries and other is for State of the countries. My question is if i select country from first dropdown thee second dropdown populate only the state of India country. -- *Thanks and Regards,* Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts data validation example.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Problem in Data Validation in Excel
Hi Jitendra.kumarverma, Find the Attachment. Hope it will help you. feel free to ask again if it is not clear. Regard, Thamu On Wed, Jan 5, 2011 at 10:27 AM, Raj Mahapatra rajafs...@gmail.com wrote: hi Jitendra, First, Define the name range of the countries as Country Second, Define the name range of states as Country Name e.g. For all indian states give name range India Third, In first column use data validation of country in Second column use this formulat in Data Validation in List as =INDIRECT(SELECT THE CELL OF PREVIOUS COLUMN WHERE YOU HAVE USED COUNTRY) If you have further problem, kindly view the attachment. On Tue, Jan 4, 2011 at 8:45 PM, Jitendra Verma jitendra.kumarve...@gmail.com wrote: Hi All, I have a question related to data validation in excel. Below is the description.. I want to create two dropdown list using the data validation list. one is for countries and other is for State of the countries. My question is if i select country from first dropdown thee second dropdown populate only the state of India country. -- *Thanks and Regards,* Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts multiple validation.xls Description: MS-Excel spreadsheet