Re: $$Excel-Macros$$ VLOOKUP FROM A RANGE OF SHEETS
Thanks All !!! On Fri, Jun 8, 2012 at 3:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Follow Noorain's method... On Fri, Jun 8, 2012 at 11:07 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Yes, Sure Vivek it is possible.. Please use =vlookup(Lookup value,Index File refernce,File No.,0) it will better if you share a sample workbook with group On Fri, Jun 8, 2012 at 10:12 AM, vivek vivek.j...@gmail.com wrote: I have created a file index , with separate sheets alphabetically. ** ** Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? ** ** Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Regards, Anoop -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....
Hi Friends, I have to add combo box in a sheet that will contain all sheets name and when i select the any sheet name in combo box, it will activate in the workbook, means I can able to see the contents of sheet simply by selecting the sheet from combo box list. Moreover, combo box should automatically update the sheet name, means if i deleted any sheet from workbook the entry from the combo box should also be deleted. Thanks a lot. Please help Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....
Such people should be ban for lifetime from this group. And I request you to please do needful. Thanks. Mangesh On Fri, Jun 8, 2012 at 5:08 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ayush, Please ban below email ID vzukauskien...@gmail.com On Fri, Jun 8, 2012 at 5:07 PM, Deba Ranjan drdeva...@gmail.com wrote: i agree with Mangesh. its seems very critical abuse word. Thanks Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 4:50 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: What do u say so... It shouldn't happen On Fri, Jun 8, 2012 at 4:49 PM, Viktorija Zukauskiene vzukauskien...@gmail.com wrote: fuck off, and never sand that forrever ok? 2012/6/8 Mangesh Dayne mangesh.da...@gmail.com Hi Friends, I have to add combo box in a sheet that will contain all sheets name and when i select the any sheet name in combo box, it will activate in the workbook, means I can able to see the contents of sheet simply by selecting the sheet from combo box list. Moreover, combo box should automatically update the sheet name, means if i deleted any sheet from workbook the entry from the combo box should also be deleted. Thanks a lot. Please help Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email
$$Excel-Macros$$ Need Help - To rename the sheet
Hi Friends, I came across good scenario while working in excel. I have the worksheet named *Result* which contain important data and whenever I open the file I need this Result sheet should become Result_1 automatically, so that there should not be *Result* sheet available in workbook. If I open the file again it should be rename Result_2 then Result_3 like this. In this way I will work on result sheet and all previous file would become Result_1, Result_2, Result_3, Result_4, etc. Please help me by providing suitable code. And also tell me where I have to put this code. Appreciate your help for this !!! Mangesh. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need Help - To rename the sheet
My God ! So Quick !! Even Shatabdi Express is not so Fast !!! Thank you so much Rajan On Thu, Jun 7, 2012 at 8:28 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Use this: ** ** Private Sub Workbook_Open() Dim wksSheet As Worksheet For Each wksSheet In Me.Worksheets If wksSheet.Name Like Result* Then wksSheet.Name = Result_ Val(WorksheetFunction.Substitute(wksSheet.Name, Result_, )) + 1 End If Next wksSheet End Sub ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* 07 June 2012 8:17 *To:* excel-macros@googlegroups.com; Mangesh Dayne *Subject:* $$Excel-Macros$$ Need Help - To rename the sheet ** ** Hi Friends, ** ** I came across good scenario while working in excel. I have the worksheet named *Result* which contain important data and whenever I open the file I need this Result sheet should become Result_1 automatically, so that there should not be *Result* sheet available in workbook. If I open the file again it should be rename Result_2 then Result_3 like this. In this way I will work on result sheet and all previous file would become Result_1, Result_2, Result_3, Result_4, etc. Please help me by providing suitable code. And also tell me where I have to put this code. ** ** Appreciate your help for this !!! ** ** Mangesh. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: FW: $$Excel-Macros$$ Need Help - To rename the sheet
Hi Rajan, Its working fine now. Thanks again. Mangesh On Thu, Jun 7, 2012 at 8:39 PM, Rajan_Verma rajanverma1...@gmail.comwrote: I think I misunderstood your question , you can use this macro : ** ** Private Sub Workbook_Open() Dim wksSheet As Worksheet For Each wksSheet In Me.Worksheets If wksSheet.Name = Result Then wksSheet.Copy , ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count) ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count).Name = Result_ ThisWorkbook.Worksheets.Count - 1 Exit Sub End If Next wksSheet End Sub ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* Rajan_Verma [mailto:rajanverma1...@gmail.com] *Sent:* 07 June 2012 8:28 *To:* 'excel-macros@googlegroups.com' *Subject:* RE: $$Excel-Macros$$ Need Help - To rename the sheet ** ** Use this: ** ** Private Sub Workbook_Open() Dim wksSheet As Worksheet For Each wksSheet In Me.Worksheets If wksSheet.Name Like Result* Then wksSheet.Name = Result_ Val(WorksheetFunction.Substitute(wksSheet.Name, Result_, )) + 1 End If Next wksSheet End Sub ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* 07 June 2012 8:17 *To:* excel-macros@googlegroups.com; Mangesh Dayne *Subject:* $$Excel-Macros$$ Need Help - To rename the sheet ** ** Hi Friends, ** ** I came across good scenario while working in excel. I have the worksheet named *Result* which contain important data and whenever I open the file I need this Result sheet should become Result_1 automatically, so that there should not be *Result* sheet available in workbook. If I open the file again it should be rename Result_2 then Result_3 like this. In this way I will work on result sheet and all previous file would become Result_1, Result_2, Result_3, Result_4, etc. Please help me by providing suitable code. And also tell me where I have to put this code. ** ** Appreciate your help for this !!! ** ** Mangesh. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
Re: $$Excel-Macros$$ Need Help
Hi friends, pls do needful. Thanks. Mangesh. [sent frm phone] On 6/7/12, Mangesh Dayne mangesh.da...@gmail.com wrote: Hi Friends, Please find the attached sheet and for this, I need average for the pivot table. Also explain me procedure. Thanks Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ How to disable all macros initially when i open the workbook
Hi Friends, I am working with the file containing macros. I want all macros should be disable when i opened the file and should be enable when i click on command button in file. My intention is to stop executing the macro just after opening the file. It should be run only when i click on command button. Please help. MAnGesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Congrats Rajan + Noorain + Vijay = Excel Group Keep it up Enjoy !!! MangesH On Mon, Jun 4, 2012 at 11:24 AM, Nikhil Shah nikhil201...@gmail.com wrote: Congratulation Rajan Nikhil Shah On Mon, Jun 4, 2012 at 11:02 AM, Maries talk2mar...@gmail.com wrote: *Congrats Brother.* On Sun, Jun 3, 2012 at 9:36 PM, Anil Gawli gawlianil8...@gmail.comwrote: congrats Mr Rajan. Gawli Anil On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Congratulation Rajan.. On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain jainayus...@gmail.comwrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of May'2012 He has posted 147 posts in May 2012 and helped many people through his expertise. I truly appreciate his consistency and commitment to group. He is really doing great job God bless you :) Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Trust me, It requires big heart to help others voluntarily and thanks to everyone who is supporting this forum. Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not
Re: $$Excel-Macros$$ can we round figer any amount.
Hi, So it can be solved by using VBA if elseif statement. MangesH On Thu, May 31, 2012 at 3:24 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Hello everybody,** But if we want like under example ….. Amount Round figer 1864138 190 361408 40 465654 50 445000 40 12 10 15 10 16 20 123 100 150 100 155 200 1234 1000 1500 1000 1555 2000 Regards LAKSHMAN *From:* Asa Rossoff a...@lovetour.info *To:* excel-macros@googlegroups.com *Sent:* Thursday, May 31, 2012 7:16 AM *Subject:* RE: $$Excel-Macros$$ can we round figer any amount. Hi Anil, To get the exact results you indicated (10% of rounding up to next 100,000), you can use any one of these formulas: =ROUNDUP(A2,-5)/10 =ROUNDUP(A2/10,-4) =(INT(A2/10)+(A2/10INT(A2/10)))*1 The ROUNDUP formulas will work with positive or negative numbers, but if you will be working with negative numbers, verify that the rounding behavior is as desired (ROUNDUP rounds away from zero rather than up). The INT formula as written always rounds up (positives away from zero, negatives towards zero). Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Wednesday, May 30, 2012 4:27 AM To: excel-macros Subject: $$Excel-Macros$$ can we round figer any amount. Hello everybody, I have a queary. can we round figer any amount. exp. Amount Round figer 975567.6510.00 732530.608.00 595328.81 457717.00 405543.09 323739.86 317619.89 317311.64 290630.55 270986.07 Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions
Re: $$Excel-Macros$$ Need help for Domain Codes
Really Awesome. Genuine Thanks ! MangEsh On Tue, May 29, 2012 at 11:20 PM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** *See the attached file, Just Type the domain Name and Hit enter* ** ** *In worksheet Module* Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 5 And Target.Column = 2 Then Application.EnableEvents = True Call Extract Application.EnableEvents = True End If End Sub ** ** ** ** *In Standard Module* Sub Extract() If Range(rngLookup).Value Then Range(rngRange).CurrentRegion.ClearContents Range(rngLookupArray).CurrentRegion.AutoFilter 2, * Range(rngLookup).Value * Range(rngLookupArray).CurrentRegion.SpecialCells(xlCellTypeVisible).Copy Range(rngRange) Range(rngLookupArray).CurrentRegion.AutoFilter Else MsgBox Please Enter a Domain Name, vbInformation, Enter Domain End If End Sub ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* 29 May 2012 7:32 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need help for Domain Codes ** ** Hi Friends, ** ** I need your help for Domain Codes search for file. Please find the attached sheet. ** ** ** ** With regards, ** ** MAnGesh ** ** ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MACRO
Hi Noorain bhai, Instead of sending the file to individual's mail id, u can send it to group so that any member could share it. Mangesh On Wed, May 30, 2012 at 2:45 PM, abhishek agarwal abhishekagarwal...@gmail.com wrote: Dear Noorain Sir , Please send me also. abhishekagarwal...@gmail.comsagarkasangottu...@gmail.com Thanks Regards, Abhishek On Wed, May 30, 2012 at 2:41 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Noorain, Please send me for 2007 also. sagarkasangottu...@gmail.com. Thanks Regards, Ksagar On Wed, May 30, 2012 at 1:01 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: me 2 plz *From:* pawel lupinski lupins...@yahoo.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Wednesday, May 30, 2012 5:39 AM *Subject:* Re: $$Excel-Macros$$ MACRO Hi Noorain Please send the files thanks Pawel *From:* Aruna jayaram aruna2...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, May 29, 2012 8:29 PM *Subject:* Re: $$Excel-Macros$$ MACRO Hi Noorain Please send the files for excel 2007. thanks On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sagar, Please find attached study material of Basic Macro and follow excel-macro group on regular basis. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 2:28 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear All, I want to learn MACRO's from basic so kindly give me some material for the same. Thanks Regards, K SAGAR -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links
Re: $$Excel-Macros$$ combo box in excel
Hi Smitha, Use data validation from Excel. MAngesH On Tue, May 29, 2012 at 2:01 PM, Smitha S R sperdwo...@gmail.com wrote: How we can place a combo box in excel work sheet? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Please help on the data validation
Check mails of this group. It has been already answered some days before. ManGesh On Tue, May 29, 2012 at 1:36 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils should come in the first line. Please help on this, if this is possible in data validation Thanks Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MACRO
Hi Noorain, Send same for Excel 07 Please. Thanks MAnGesh On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sagar, Please find attached study material of Basic Macro and follow excel-macro group on regular basis. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 2:28 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear All, I want to learn MACRO's from basic so kindly give me some material for the same. Thanks Regards, K SAGAR -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MACRO
Noorain bhai, Dhanyawad Kya kahu... Agar dhanyawad ki hi bat hai to hamesha yahi dil se kahta rahunga... U R SIMPLY OXYGEN OF THIS GROUP DEAR with regards, MangEsh. On Tue, May 29, 2012 at 6:35 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *I just study Excel 2003 Power programming with VBA by J-Walk when I started to learn VBA* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *SAGAR KASANGOTTUWAR *Sent:* 29 May 2012 2:28 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ MACRO ** ** Dear All, ** ** I want to learn MACRO's from basic so kindly give me some material for the same. ** ** ** ** Thanks Regards, ** ** K SAGAR -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Need help for Domain Codes
Hi Friends, I need your help for Domain Codes search for file. Please find the attached sheet. With regards, MAnGesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Domain Code Search.xlsm Description: Binary data
Re: $$Excel-Macros$$ Need help for Domain Codes
Hi Rajan, Please find the sheet consists of sample data on sheet2. Thanks ManGesh On Tue, May 29, 2012 at 9:25 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Can u explain with data? ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* 29 May 2012 7:32 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need help for Domain Codes ** ** Hi Friends, ** ** I need your help for Domain Codes search for file. Please find the attached sheet. ** ** ** ** With regards, ** ** MAnGesh ** ** ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Domain Code Search.xlsm Description: Binary data
Re: $$Excel-Macros$$ latest data to be highlighted
HI Amit, Thats good but can you share your answer within group so that excel lovers like me could understand it for future ref. U can attached solved sheet too. Thanks With regards, Mangesh On Mon, May 28, 2012 at 10:41 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: I got the solution by some RD.. thanks a lot. ** ** Best Regards, Amit ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU) *Sent:* 27 May 2012 01:01 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ latest data to be highlighted ** ** Dear Friends, ** ** Please help me with a formula or any other solution. I wants to remove the old keep only latest dated data from the attached sample file. ** ** The file contains history of cabs going for PM service to WS on particular days. I wants to get when the last time it visited WS. As of now I am taking count of cab in table also finding the number of time ( 1st, 2nd, 3rd ) it visited WS. Thus if cab visited 3 times I have to remove its 1st 2 nd visit, like wise I need to do for all such cabs...but this method is lengthy... ** ** Can you please help me with some formula where in at least I can get the latest dated data highlighted? ** ** Best Regards, Amit ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Search domain in list and shows related names having the domain
Hi All, Please help me on below query. With regards, Mangesh On Mon, May 28, 2012 at 5:12 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: HI Noorain, Thanks for your reply. However, I didn't get about the red highlighted code. I have attached snapshot about what I need. Please find it and help me. Let me know if you need more details on same. Thanks again dear. Mangesh On Fri, May 25, 2012 at 11:20 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: *Dear Mangesh, Please Change only red color part Sub search_domain() Dim rng As Range Dim rw As Long Dim sh1 as worksheet Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) * *Set sh1 = ThisWorkbook.Sheets(2) * *sh.Range(D2:E7).ClearContents For Each rng In sh1.Range(H3:H sh.Range(H Rows.Count).End(xlUp).Row) If Right(rng, Len(rng) - InStr(1, rng, @)) = Range(B1) Then With sh rw = .Cells(Rows.Count, E).End(xlUp).Row + 1 .Cells(rw, E).Value = rng.Offset(0, 0) .Cells(rw, D).Value = rng.Offset(0, -1) End With End If Next rng End Sub * On Fri, May 25, 2012 at 11:13 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: By the way Noorain, Is it possible in this example to search email in another sheet containing mails and names. What we could do for this? Please assist. On Fri, May 25, 2012 at 11:05 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Thanks Mangesh... On Fri, May 25, 2012 at 11:04 PM, Mangesh Dayne mangesh.da...@gmail.com wrote: Simply Awesome !!! On Fri, May 25, 2012 at 8:27 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please try it... *Sub search_domain() Dim rng As Range Dim rw As Long Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) sh.Range(D2:E7).ClearContents For Each rng In sh.Range(H3:H sh.Range(H Rows.Count).End(xlUp).Row) If Right(rng, Len(rng) - InStr(1, rng, @)) = Range(B1) Then With sh rw = .Cells(Rows.Count, E).End(xlUp).Row + 1 .Cells(rw, E).Value = rng.Offset(0, 0) .Cells(rw, D).Value = rng.Offset(0, -1) End With End If Next rng End Sub * See attached sheet. Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, May 25, 2012 at 6:57 PM, Mangesh Dayne mangesh.da...@gmail.com wrote: Thanks Noorain for your kind help. However, I need all the names with their mail id those we are searching for the domain code. For example, if we enter rediff.com in search box, then it would show - Name Email Amit a...@rediff.com Rajan ra...@rediff.com Please help me on above. Thanks again. Mangesh On Fri, May 25, 2012 at 6:04 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please try it..and see attached sheet.. Sub search_domainname() Dim rng As Range Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For Each rng In sh.Range(H3:H8) If Right(rng, Len(rng) - InStr(1, rng, @)) = Range(B1) Then MsgBox Found in Cell vbCrLf rng.Address Exit Sub End If Next rng MsgBox Not Found End Sub -- On Fri, May 25, 2012 at 5:29 PM, Mangesh Dayne mangesh.da...@gmail.com wrote: Hi All, Please help me on attached sheet. Thanks lot. with regards, Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum
Re: $$Excel-Macros$$ latest data to be highlighted
Hi Amit, Thanks and nice example to do study of Count() function. Mangesh On Mon, May 28, 2012 at 7:45 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Mangesh, ** ** Please find attached simple solution that could not click when i was working under pressure...but later today it clicked me... ** ** Best Regards, Amit ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* 28 May 2012 17:29 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ latest data to be highlighted ** ** HI Amit, ** ** Thats good but can you share your answer within group so that excel lovers like me could understand it for future ref. U can attached solved sheet too. ** ** Thanks ** ** ** ** With regards, ** ** Mangesh ** ** On Mon, May 28, 2012 at 10:41 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: I got the solution by some RD.. thanks a lot. Best Regards, Amit *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU) *Sent:* 27 May 2012 01:01 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ latest data to be highlighted Dear Friends, Please help me with a formula or any other solution. I wants to remove the old keep only latest dated data from the attached sample file. The file contains history of cabs going for PM service to WS on particular days. I wants to get when the last time it visited WS. As of now I am taking count of cab in table also finding the number of time ( 1st, 2nd, 3rd ) it visited WS. Thus if cab visited 3 times I have to remove its 1st 2 nd visit, like wise I need to do for all such cabs...but this method is lengthy... Can you please help me with some formula where in at least I can get the latest dated data highlighted? Best Regards, Amit -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED
$$Excel-Macros$$ Search domain in list and shows related names having the domain
Hi All, Please help me on attached sheet. Thanks lot. with regards, Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Search domain codes in data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Using filter by Keyboard shortcuts
Hi, I have use filter by keyboard shortcuts. Find the attached sheet. I know the shortcut keys for doing so like Alt+ A, T but how to select filter option in sheet (handle and elements in it). Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Filter by Keyboard Shortcuts.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Using filter by Keyboard shortcuts
Yes Noorain, no doubt, you always provide accurate answer for questions/queries in this group. Genuine Thanks for your support. Mangesh On Fri, May 25, 2012 at 10:05 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear NOORAIN Sir, Thanks for quick response. it very good to start for new user Thanks Regards, Prajakt Pande +971551388482 ** On Fri, May 25, 2012 at 8:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Prajakt, Please find attached Shortcut Keys version wise.. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, May 25, 2012 at 8:57 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear NOORAIN Sir, Thanks for this shortcut, *To Group,* Can any one share all shortcut for excel 2003, 2007 and 2007+. it would be appreciate if given in version wise Thanks Regards, Prajakt Pande +971551388482 ** On Fri, May 25, 2012 at 7:16 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, To Create filter you can also use Short-Cut keys a). Alt+dff (2003+) b). ctrl+shfit+L(2007+) and select filtered option you can use Alt+Down arrow Is your requirment is this or Not If not pls explain more. On Fri, May 25, 2012 at 7:24 PM, Mangesh Dayne mangesh.da...@gmail.com wrote: Hi, I have use filter by keyboard shortcuts. Find the attached sheet. I know the shortcut keys for doing so like Alt+ A, T but how to select filter option in sheet (handle and elements in it). Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums
Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.
Hi All, Welcome decision. In addition, it is also good that job posting should be related to excel, vba only. Our objective is to make universal platform for EXCEL/VBA LOVERS. with regards, Mangesh On Mon, May 21, 2012 at 7:10 PM, prernacha...@ymail.com wrote: ** Hi Ayush sir, Can you plz exlude me from this forum. Sent on my BlackBerry® from Vodafone -- *From: * Ayush Jain jainayus...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Sun, 20 May 2012 07:54:03 -0700 (PDT) *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ NEW RULE : No more job postings in this forum. Hello everyone, There is sudden increase in job posts and more than half of all job posts are irrelevent not related to excel. I have decided not to allow any jobs whether related to excel or not. *This is not employment forum and intended to help on excel queries only.* Anyone found posting jobs will be banned without any warning. Let me know if you have any questions. Regards Ayush Jain Group Manager and Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Time Difference
Hi Friends, Please help me on this issue. Please refer the attached file. In file, I need time at other countries depending on the time in Mumbai. Time difference is mentioned in the sheet. Please help me by providing answer/vba code. Thanks Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Time_Difference.xlsm Description: Binary data
Re: $$Excel-Macros$$ Time Difference
Hi, Thanks for your great help. In vba code, Range(C11).Value = Range(C10) + 0.2916667 why did you have taken 0.2916667 value and many other in formula. Please explain the logic behind it. Thanks Mangesh On Wed, May 16, 2012 at 6:43 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attachments.. -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Time Difference
Thanks Rajan On Wed, May 16, 2012 at 7:20 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI You can use this also =C10+(HOUR(NOW()+INT(RIGHT(C3)-LEN(C3)-1))) Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?» lal?? ?sa?? Sent: 16 May 2012 7:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Time Difference Dear Mangesh PFA Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 6:48 PM, Mangesh Dayne mangesh.da...@gmail.com wrote: Hi, Thanks for your great help. In vba code, Range(C11).Value = Range(C10) + 0.2916667 why did you have taken 0.2916667 value and many other in formula. Please explain the logic behind it. Thanks Mangesh On Wed, May 16, 2012 at 6:43 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attachments.. -- MARIES Excel Inspiration -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. - - To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you
$$Excel-Macros$$ Pls help for expression col no * 25 + row no
I am happy for your kind support Pls help me again for below issue . Find attached sheet Thanks. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Expression colno.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no
Thanks It works. On Wed, May 16, 2012 at 9:41 PM, Maries talk2mar...@gmail.com wrote: Hi, Try it, * =COLUMN()*25+ROW()* On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: I am happy for your kind support Pls help me again for below issue . Find attached sheet Thanks. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION
Its really valuable material and study file I have ever seen in my life...!!! User friendly Thanks friend !!! U r simply gr8. On Tue, May 15, 2012 at 6:34 PM, danial mansoor danial_...@hotmail.comwrote: dear Noorani, do you have material for intermediate level user in which macro and other material related to advance is not included. plz send me. -- Date: Tue, 15 May 2012 15:27:57 +0530 Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Rakesh, Please find attached study materials. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 15, 2012 at 2:31 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi, I want to learn All excel formula functions their use, so plz share links or files if any with you. - Thanks Regards, Rakesh Kumar Sharma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Need help !!!
Hi all, I have created small code but it is showing error message as Object required. *The code is -* Sub gen() If Sheet1.Range(A2).Value 50 Then Sheet1.Range(B2).Text = You have entered the value above 50 Else Sheet1.Range(B2).Text = You have entered the value below 50 End If End Sub Whats wrong with the code. Please advice me. Thanks. Mangesh. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need help !!!
Ok. Thanks rajan. On Tue, Apr 10, 2012 at 10:17 PM, Rajan_Verma rajanverma1...@gmail.comwrote: I think Text is a read only property here ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* Apr/Tue/2012 10:16 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need help !!! ** ** Thanks Rajan It works so it means that - we generally use text property in VB but in excel it takes value property. So is there many differences in terms of property and events in excel macro vba and simply vb ? On Tue, Apr 10, 2012 at 10:13 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Use value property instead of Text *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* Apr/Tue/2012 10:12 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need help !!! Hi all, I have created small code but it is showing error message as Object required. *The code is -* Sub gen() If Sheet1.Range(A2).Value 50 Then Sheet1.Range(B2).Text = You have entered the value above 50 Else Sheet1.Range(B2).Text = You have entered the value below 50 End If End Sub Whats wrong with the code. Please advice me. Thanks. Mangesh. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already
Re: $$Excel-Macros$$ Need chart related vba codes
Hi Rajan, Thanks. I have checked the link but was unable to download it. Kindly help !!! On Fri, Apr 6, 2012 at 10:35 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Mangesh Here is the link for that amazing book.. http://ebookee.org/Charts-and-Graphs-for-Microsoft-Office-Excel-2007_766373.html ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* Apr/Fri/2012 10:16 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need chart related vba codes ** ** Thanks Rajan, ** ** Can you provide me URL for Excel Chart and Graph by Mr.Excel . Kind regards, ** ** Mangesh On Fri, Apr 6, 2012 at 9:00 PM, Rajan_Verma rajanverma1...@gmail.com wrote: HI Mangesh For any type of editing of chart you can find codes from google.. but to understand charts. You must know object model of Excel Charts, try to learn Property and method of chartobjects and chart. You can download the book for Chart.. Excel Chart and Graph by Mr.Excel Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* Apr/Fri/2012 08:30 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need chart related vba codes Hi All, Can you send me chart related vba codes like creating, editing chart based on the data in Excel. Kind regards, Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post
$$Excel-Macros$$ Need chart related vba codes
Hi All, Can you send me chart related vba codes like creating, editing chart based on the data in Excel. Kind regards, Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need chart related vba codes
Thanks Rajan, Can you provide me URL for Excel Chart and Graph by Mr.Excel . Kind regards, Mangesh On Fri, Apr 6, 2012 at 9:00 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Mangesh For any type of editing of chart you can find codes from google.. but to understand charts. You must know object model of Excel Charts, try to learn Property and method of chartobjects and chart. You can download the book for Chart.. Excel Chart and Graph by Mr.Excel ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne *Sent:* Apr/Fri/2012 08:30 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need chart related vba codes ** ** Hi All, ** ** Can you send me chart related vba codes like creating, editing chart based on the data in Excel. ** ** ** ** Kind regards, ** ** Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Mangesh Dayne wants to chat
--- Mangesh Dayne wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-39630eaae8-0f6e46ff2e-POa8AcgjdL8eh-GF-4az46SJV4s You'll need to click this link to be able to chat with Mangesh Dayne. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with Mangesh Dayne, visit: http://mail.google.com/mail/a-39630eaae8-0f6e46ff2e-POa8AcgjdL8eh-GF-4az46SJV4s Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into conversations - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Need your help !!!
Hi Rajan, I need some web links for the study material of excel vba. So kindly send me links so that I could learn vba. With regards, Mangesh Dayne -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Email Sheet with message
Hi Darwin, If you are not able to see mentioned reference Microsoft Outlook 12.0 Object Library in your machine, then probably you can get it by installing VB 6.0 edition in your computer. Mangesh. On Wed, Mar 28, 2012 at 3:49 PM, Jorge Marques leote.w...@gmail.com wrote: Talal, i´m also a beginner, i´m using some books, but i haven´t found any extensive one in VBA, i use recording methods to see what the code performs, and use other posts to see what it returns in the excel provided, it has helped me a lot improving my skills, i notice that i not still able to build code by myself, but know, I can read and understand what it means, so i can build macros but taking pieces from other macros and adapt to what i pretend, and when i have doubts this forum is 100% perfect. i hope someday i can be the one responding to solutions and not asking for them :), wish you the best in this Excel world. 2012/3/28 Darwin Chan darwin.chankaw...@gmail.com Hi all, I found this thread which is really useful, however, I couldnt find the Tools-Reference-Microsoft Outlook 12.0 Object Library as mentioned by Noorain MS Excel 2000 version How could I get access to the Library? 2012/3/20 NOORAIN ANSARI noorain.ans...@gmail.com Dear Talal, It's really simple but it takes some time. Spend 2-3 hours a day, every day, in these forums reading posts and trying the solutions provided. Experiment! Try to Create simple macro by help of record macro,Google,Books. Hope your Excel-VBA will surely improve. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 14, 2012 at 12:39 PM, Muhammad Talal Akbar sh.talal.ak...@gmail.com wrote: Hi Mr. Ansari how are you? My dear i need your help can u guide me; how can i improve my skills in excel and VBA regards, On Wed, Mar 14, 2012 at 11:20 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Please add Outlook library before run the code Tools-Reference-Microsoft Outlook 12.0 Object Library. On Wed, Mar 14, 2012 at 11:13 AM, LearnExcel sendse...@gmail.comwrote: i'm using the following code to send email how do i add something to the body? does anyone know if its possible to add a message to the email? ThisWorkbook.Sheets(1).Copy With ActiveWorkbook .SendMail Recipients:=emailaddr...@df.com, _ Subject:=Try Me) .Close SaveChanges:=False End With *End Sub* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ InternetExplorer-automation work-Some crtical
Hi. Thanks for your kind support. Would you please provide me User name and password so that I could login. Thanks. Mangesh On Thu, Feb 16, 2012 at 6:08 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, We all using of web site https://i-navigator.industowers.com, In this web site i will take Csv filesdumps from every 10 minutes with manual , If any possible to take VBA Code with automation . I explain my work in Excel shetet with screen shots ,u need any User name password give ur personal mail id i will send u... -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com