Re: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .....)
Dear Ravinder negi, you are right, in certain pay slips there is some difference like S#:87 is payslip of a Naib Qasid where on allowance named Washing Allowance is extra then usual Allowances. So i am sorry that I could not mention it in my query, so it is also a problem sir, please do some trick help me to get rid from this problem I hope you people can do this. Thanks for taking time asked me about this problem, Please do ask me if there is any other confusion. On Wednesday, November 6, 2013 11:58:39 AM UTC+5, ravinder negi wrote: PFA, If its ok.. there is only one problem with below data, its having extra row(yellow color) S#:87 P Sec:001 Month:September 2013 TT6048 -A.D.O.E(M) SUJAWAL Pers #: 10342551 Buckle: Min: Edu/Liter N-For Edu Dep Name: ABDUL RAUF MEMON NTN: Dsg.: NAIB QASID GPF #: CNIC No.4140822125719 Old #: GPF Interest Applied 02 Active PermanentTT6048- PAYS AND ALLOWANCES: 0001-Basic Pay 9,490.00 1000-House Rent Allowance910.00 1210-Convey Allowance 20051,700.00 1300-Medical Allowance 1,000.00 1567-Washing Allowance30.00 1948-Adhoc Allowance 2010@ 50% 2,767.00 1970-Adhoc Relief Allow 2011 830.00 2118-Adhoc Relief Allow (2012) 1,898.00 2149-Adhoc Allowance 2013 @15% 1,423.00 Gross Pay and Allowances 20,048.00 *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *M.Rafique MRU *Sent:* Wednesday, November 06, 2013 10:11 AM *To:* excel-macros *Subject:* $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .) Hi Dear Excel Gurus, Once again I am having a huge problem regarding data entry of of employees pay roll, i have attached a workbook in which sheet PayRoll contains all the data but in merged column or single column in vertical column like A1 ( in which Personal No. Name of employee are written in same column) now i want Personal No. in one column Name of Employee in another column, I have labelled my sheet to clear my requirement and I have also created another worksheet named Data where is a required format for retrieval of data from PayRoll. Hope, I will receive same response from you experts as before, thanks you in advance. Muhammad Rafique Ujjan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their
RE: $$Excel-Macros$$ Advanced Filter Not Working Properly
Pfa, try this one.. if help you From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Hilary Lomotey Sent: Tuesday, November 05, 2013 10:48 PM To: excel-macros Subject: $$Excel-Macros$$ Advanced Filter Not Working Properly Hello Experts, i need your expert advice, have recorded a macro using advanced filter, when you debug and run it it works flawlessly, however when i can it in a user form, it doesnt work properly, any ideas how to salvage this? .thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. ADVANCEFILTERBYVBA.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
RE: $$Excel-Macros$$ Calculate cogs avg basis in Excell
Dear at least reply to my query.Pleas help i have hopes with u all guyss. From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Calculate cogs avg basis in Excell Date: Tue, 5 Nov 2013 22:39:18 +0500 Dear expert , plz help From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Calculate cogs avg basis in Excell Date: Tue, 5 Nov 2013 00:30:48 +0500 Dear Expert. In attached sheet i have transaction sheet where all purchase and sales is entered .From this sheet i want to calculate cogs product wise on avg basis .For this i use pivot table and create formula but it only calculate avg cogs for one product .Please check and help . COGS formula=Opp stock amt(manually input) +purchase amount upto date -sum of cogs one day before/ Opp stock qty(manually input) +sum purchase qty up-to date -sum of unit sold one day before. If someone know better option to calculate cogs product wise avg basis please suggest and help me. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .....)
Thanks a lot dear Ravinder Negi for solving my problem. On Wednesday, November 6, 2013 5:13:27 PM UTC+5, ravinder negi wrote: Pls try this one… *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *MRafique Ujjan *Sent:* Wednesday, November 06, 2013 3:45 PM *To:* excel-...@googlegroups.com javascript: *Cc:* Soum *Subject:* Re: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .) Dear Ravinder negi, you are right, in certain pay slips there is some difference like S#:87 is payslip of a Naib Qasid where on allowance named Washing Allowance is extra then usual Allowances. So i am sorry that I could not mention it in my query, so it is also a problem sir, please do some trick help me to get rid from this problem I hope you people can do this. Thanks for taking time asked me about this problem, Please do ask me if there is any other confusion. On Wednesday, November 6, 2013 11:58:39 AM UTC+5, ravinder negi wrote: PFA, If its ok.. there is only one problem with below data, its having extra row(yellow color) S#:87 P Sec:001 Month:September 2013 TT6048 -A.D.O.E(M) SUJAWAL Pers #: 10342551 Buckle: Min: Edu/Liter N-For Edu Dep Name: ABDUL RAUF MEMON NTN: Dsg.: NAIB QASID GPF #: CNIC No.4140822125719 Old #: GPF Interest Applied 02 Active PermanentTT6048- PAYS AND ALLOWANCES: 0001-Basic Pay 9,490.00 1000-House Rent Allowance910.00 1210-Convey Allowance 20051,700.00 1300-Medical Allowance 1,000.00 1567-Washing Allowance30.00 1948-Adhoc Allowance 2010@ 50% 2,767.00 1970-Adhoc Relief Allow 2011 830.00 2118-Adhoc Relief Allow (2012) 1,898.00 2149-Adhoc Allowance 2013 @15% 1,423.00 Gross Pay and Allowances 20,048.00 *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On Behalf Of *M.Rafique MRU *Sent:* Wednesday, November 06, 2013 10:11 AM *To:* excel-macros *Subject:* $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .) Hi Dear Excel Gurus, Once again I am having a huge problem regarding data entry of of employees pay roll, i have attached a workbook in which sheet PayRoll contains all the data but in merged column or single column in vertical column like A1 ( in which Personal No. Name of employee are written in same column) now i want Personal No. in one column Name of Employee in another column, I have labelled my sheet to clear my requirement and I have also created another worksheet named Data where is a required format for retrieval of data from PayRoll. Hope, I will receive same response from you experts as before, thanks you in advance. Muhammad Rafique Ujjan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Re: $$Excel-Macros$$ Advanced Filter Not Working Properly
thanks for the assistance. On Wed, Nov 6, 2013 at 10:14 AM, Ravinder ravinderexcelgr...@gmail.comwrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (ravinderexcelgr...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DNlRO%252FKMub%252B17NQ7BLmaiF6yCsgQsqXhc0s%252FemdtwcWpZ6%252B2AuhEK817BWTOBJNwG5lwQtKuOlslUoSzsyEFt8Ho018xzz8Ex5tKAC9q84DTyPx1EJzt04DMvho43dYLJ66vS4Grw2iM21ACKSqd4FA%253D%253D%26key%3DHMdZkZxhUh10i1%252FWDJq5%252F%252FKh1S9TcDooJ%252FrnQ5TqaiQ%253Dtc_serial=15597929668tc_rand=1136619735utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=15597929668tc_rand=1136619735utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 Pfa, try this one.. if help you *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey *Sent:* Tuesday, November 05, 2013 10:48 PM *To:* excel-macros *Subject:* $$Excel-Macros$$ Advanced Filter Not Working Properly Hello Experts, i need your expert advice, have recorded a macro using advanced filter, when you debug and run it it works flawlessly, however when i can it in a user form, it doesnt work properly, any ideas how to salvage this? .thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to
$$Excel-Macros$$ loop to copy items one by one
Hello Experts, i need assistance with a loop or any macro to help run a report. ie in the sheet attached i have a list of names, if i choose a name from the list and run the adv filter it gives me the result i want and then i will run the report and get it exported to the database. i want this process automated, ie a macro to change the name one after the other, then i will call the advanced filter and call again the macro to copy to database. i need assistance with the macro to change the name one after the other. pls assist. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Run Report.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ loop to copy items one by one
i have been able to do it thanks On Wed, Nov 6, 2013 at 7:08 PM, Hilary Lomotey resp...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DwNYggWU2VGpS7GdyCwzdCFwXcqX2934qHiIPwXeblRWFtbx%252F4nZ7weIu9mMdFKQfHgptJG8ALTlDNtwoRRo8X7%252F07JMjgnm8RfbYbR10IwRWl3hdBNM5UhS89oG8uZmaenS5MIkJgzk%253D%26key%3Dc%252FRWGq2RhZgvbs6RLJzHhpbJpYvvjZI3ONjkRLkk8cA%253Dtc_serial=15601462566tc_rand=667434941utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=15601462566tc_rand=667434941utm_source=stfutm_medium=emailutm_campaign=ANNO_CLEANUP_ADDutm_content=001 Hello Experts, i need assistance with a loop or any macro to help run a report. ie in the sheet attached i have a list of names, if i choose a name from the list and run the adv filter it gives me the result i want and then i will run the report and get it exported to the database. i want this process automated, ie a macro to change the name one after the other, then i will call the advanced filter and call again the macro to copy to database. i need assistance with the macro to change the name one after the other. pls assist. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines
I get a run time 1004 when the comment lines are at 266 lines. WIth less than 200 comment lines the code runs fine. The DropDownTmp variable list includes all 266 lines. The comment field cuts off around 253 lines of code. The program stops with the run time error. Any ideas on how to fix this? SearchRowTemp = SearchRow ErrorDesc = Sheets(SNLogNew).Cells(LogRowCounter, 1).Value Sheets(SNLogNew).Cells(LogRowCounter, 2).Value Do Until ErrorDesc = If Left(ErrorDesc, 3) = Or Sheets(SNLogNew).Cells(LogRowCounter, 1).Value = Then ' Add a comment If Not Found Then If NewComment Then Sheets(SNTD).Cells(TDRowCounter - 1, Tdf_Col_Error).AddComment Text:=Trim(ErrorDesc) Sheets(SNTD).Cells(TDRowCounter - 1, Tdf_Col_Error).Comment.Shape.TextFrame.AutoSize = True NewComment = False Else Sheets(SNTD).Cells(TDRowCounter - 1, Tdf_Col_Error).Comment.Text Text:=Sheets(SNTD).Cells(TDRowCounter - 1, Tdf_Col_Error).Comment.Text Chr(10) Trim(ErrorDesc) End If ' Determine the number of specs in the drop down list i_number_comments = Len(Sheets(SNTD).Cells(TDRowCounter - 1, Tdf_Col_Error).Comment.Text) - Len(Replace(Sheets(SNTD).Cells(TDRowCounter _ - 1, Tdf_Col_Error).Comment.Text, Chr(10), )) Debug.Print i_number_comments ' If this is the last entry of a comment... add the data validation If Left(ErrorDesc, 3) = And _ (Sheets(SNLogNew).Cells(LogRowCounter + 1, 1).Value = Or Left(Sheets(SNLogNew).Cells(LogRowCounter + 1, 1).Value, 3) ) And _ CMD_Tmp.DetailDropDown And TDRowCounter TDRow And i_number_comments 250 Then DropDownTmp = Sheets(SNTD).Cells(TDRowCounter - 1, Tdf_Col_Error).Comment.Text ' Add Drop Down Selection for Detail Cell With Sheets(SNTD).Cells(TDRowCounter - 1, Tdf_Col_Detail).Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:=DropDownTmp .IgnoreBlank = True .InCellDropdown = True .InputTitle = .ErrorTitle = .InputMessage = .ErrorMessage = .IMEMode = xlIMEModeNoControl .ShowInput = True .ShowError = True End With End If End If -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Thank you. when you need to let me know. Take a look at this link, and has several good choices of courses and tutorials VBA: http://www.mrexcel.com/forum/general-excel-discussion-other-questions/698256-online-visual-basic-applications-course.html another option this great book: http://www.4shared.com/rar/pfq_GUuR/excel_2010_vba_and_macros.html thanks, regards Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: Hi Kindly note that sql.request is functional in MS Excel 2007 but not in MS Excel 2010. Could you please let me know any VBA code that would be a substitute for sql.request. If yes, Please let me know with the help of an example. We use sql.request to transfer data from MS Access to MS Excel in version 2007 Thanks regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Calculate cogs avg basis in Excell
Could you pls give small data and your query and desired output with calculation.so we can try From: Kashan Abbas [mailto:kashanabbas...@hotmail.com] Sent: Thursday, November 07, 2013 10:36 AM To: excel-macros@googlegroups.com; xlst...@gmail.com; ravinderexcelgr...@gmail.com Subject: FW: $$Excel-Macros$$ Calculate cogs avg basis in Excell Please reply _ From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Calculate cogs avg basis in Excell Date: Tue, 5 Nov 2013 00:30:48 +0500 Dear Expert. In attached sheet i have transaction sheet where all purchase and sales is entered .From this sheet i want to calculate cogs product wise on avg basis .For this i use pivot table and create formula but it only calculate avg cogs for one product .Please check and help . COGS formula=Opp stock amt(manually input) +purchase amount upto date -sum of cogs one day before/ Opp stock qty(manually input) +sum purchase qty up-to date -sum of unit sold one day before. If someone know better option to calculate cogs product wise avg basis please suggest and help me. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ use of find method in VBA
I am taking data from one workbook and finding the same data in different workbook. I am using find method, below is my code; Dim rowcrnt As Range Dim rng As Object Workbooks(Input1_FileName).Sheets(Input1_SheetName).Activate Workbooks(Input2_FileName).Sheets(Input2_SheetName).Activate Columns(B:B).Select Set rng = Selection.Find(What:=First_Time, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False) If Not rng Is Nothing Then rowcrnt = rng.Row End If “First_Time” is the data from Input1_FileName Every time I am getting” rng” as nothing. Can anyone tell me what’s wrong in code? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST
Hi Basole Please accept my thanks for the links. I will go through them and would let you know if I have any issue and see their applicability in my risk domain. For the time being, the VBA code is running well so far. I want to work on a variant of it. Could it be possible for you to work on the same requirement for importing data from MS Access to MS Excel using querytables ? The version that you helped me with, uses recordset. I want to use querytables instead. Thanks regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Thu, Nov 7, 2013 at 8:39 AM, Basole ricardo...@gmail.com wrote: Thank you. when you need to let me know. Take a look at this link, and has several good choices of courses and tutorials VBA: http://www.mrexcel.com/forum/general-excel-discussion-other-questions/698256-online-visual-basic-applications-course.html another option this great book: http://www.4shared.com/rar/pfq_GUuR/excel_2010_vba_and_macros.html thanks, regards Basole. Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: Hi Kindly note that sql.request is functional in MS Excel 2007 but not in MS Excel 2010. Could you please let me know any VBA code that would be a substitute for sql.request. If yes, Please let me know with the help of an example. We use sql.request to transfer data from MS Access to MS Excel in version 2007 Thanks regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ loop to copy items one by one
Pfa, I think you r looking for this.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Hilary Lomotey Sent: Thursday, November 07, 2013 12:39 AM To: excel-macros Subject: $$Excel-Macros$$ loop to copy items one by one Hello Experts, i need assistance with a loop or any macro to help run a report. ie in the sheet attached i have a list of names, if i choose a name from the list and run the adv filter it gives me the result i want and then i will run the report and get it exported to the database. i want this process automated, ie a macro to change the name one after the other, then i will call the advanced filter and call again the macro to copy to database. i need assistance with the macro to change the name one after the other. pls assist. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. run report with advance filter.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
RE: $$Excel-Macros$$ use of find method in VBA
I think problem with yello highlighted color code. Pls try this if help (PFA) Sub RoundedRectangle1_Click() Dim rng As Range Sheet2.Range(a1:a9).Select Set rng = Selection.Find(What:=b, After:=Range(a1), LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False) MsgBox rng.Address If Not rng Is Nothing Then rowcrnt = rng.Row End If MsgBox rowcrnt End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rutuja patekar Sent: Thursday, November 07, 2013 11:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ use of find method in VBA I am taking data from one workbook and finding the same data in different workbook. I am using find method, below is my code; Dim rowcrnt As Range Dim rng As Object Workbooks(Input1_FileName).Sheets(Input1_SheetName).Activate Workbooks(Input2_FileName).Sheets(Input2_SheetName).Activate Columns(B:B).Select Set rng = Selection.Find(What:=First_Time, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False) If Not rng Is Nothing Then rowcrnt = rng.Row End If First_Time is the data from Input1_FileName Every time I am getting rng as nothing. Can anyone tell me what's wrong in code? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. findcommaninvba.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12