$$Excel-Macros$$ Re: Abc in a column
Hi Manoj =MID(ADDRESS(1,COLUMN()),2,1) Prince On Saturday, October 20, 2012 10:05:27 PM UTC+5:30, Manoj Kumar wrote: Hi expert I want ABC in a column. So can u help me on this. In a column ABC from a to z. Thanks Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Query related to Salary binding up
Hi all, Need help on this. Regards, Ankit On Thu, Oct 18, 2012 at 5:21 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Hi Haseeb, Thanks for your mail. this is really help me. but I have some point which can make it more effective and efficient. - Department code will be written automatically. - and , another point is, If any employee salary is going in two percentage(%) (as in sonu),we do not need to write it twice and more time. Except above point sheet and process is really good and helpful to me Regards, Ankit On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Dear All, I have a salary sheets where there are three column i.e. Name, Department and salary. I need department wise salary sheet but there is one issue.there are lots of employees whose salary is going in more then 1 department so I am confused how I bind up my salary. I mentioned my method in attached sheet.kindly give me better way to prepare it. Regards, Ankit -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Trouble in 2007
What about macro setting on your Excel 2007 application Divaker On Sun, Oct 21, 2012 at 5:30 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear experts, I have done a small project in excel 2003 with some command buttons. when i open my project in excel 2007 then command buttons are not press or working. Why this problem come in 2007? please give me settings or any suggesstion. I have checked micro to enabled and desabled but same promblems is constant. Awaiting your positive responce Regards Sajid Memon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Trouble in 2007
On Oct 21, 2012 5:31 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear experts, I have done a small project in excel 2003 with some command buttons. when i open my project in excel 2007 then command buttons are not press or working. Why this problem come in 2007? please give me settings or any suggesstion. I have checked micro to enabled and desabled but same promblems is constant. Awaiting your positive responce Regards Sajid Memon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$
Dear Rajan Thanks Regards Shrinivas On Sat, Oct 20, 2012 at 2:53 PM, Rajan_Verma rajanverma1...@gmail.comwrote: * * *Here are a simplest example,* * * *You can use this code to understand the thing about screen updating True/False* * * *ScreenUpdating is Application Property , so it works on application level, means once it set to False then it will be false for every procedure until it is not set to TRUE,* *Try to execute below procedure after and before commenting Third Last Line **J*** * * *Sub FillByloop()* *Dim lngI As Long* *Application.ScreenUpdating = False* *For lngI = 1 To 1* *[a1] = lngI* *Next* *Application.ScreenUpdating = True* *Call FillByloop2* *End Sub* * * * * *Sub FillByloop2()* *Dim lngI As Long* *For lngI = 1 To 1* *[a1] = lngI* *Next * *End Sub* * * *===* *Enjoy **J*** *===* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde *Sent:* 20 October 2012 12:01 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ ** ** Thanks to all Just one question for Knowledge I run the script by both way 1.By Making true at the end 2.Without making true at end I could not notice any difference. So please can any one explain me What is the purpose of making true at end? Aging I ma repeating this is just for Knowledge. Regards Shrinivas On Fri, Oct 19, 2012 at 6:29 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *But also make them TRUE at end of code * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde *Sent:* 19 October 2012 5:25 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Dear Both, Very very thanks for solution. Regards Shrinivas On Fri, Oct 19, 2012 at 1:19 PM, v...@vabs.in wrote: Hi Just put Application.Screenupdating = False Rgds// Vabs Sent on my BlackBerry® from Vodafone -- *From: *Shrinivas Shevde shrinivas...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 19 Oct 2012 12:29:55 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Dear Group member, I wrote small macro which works fine. But when I run macro it shows all action i.e everything ishappening in front of user which I dont want . I want that when I run macro Worksheet should be steady and all actions should happen at backend. How to do it please let me know. Is ther any extra code needs to write. -- Shrini -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated
Re: $$Excel-Macros$$
Dear Tem members, can anyone explain me how to protect the code Regards Shrinivas On Mon, Oct 22, 2012 at 4:44 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear Rajan Thanks Regards Shrinivas On Sat, Oct 20, 2012 at 2:53 PM, Rajan_Verma rajanverma1...@gmail.comwrote: * * *Here are a simplest example,* * * *You can use this code to understand the thing about screen updating True/False* * * *ScreenUpdating is Application Property , so it works on application level, means once it set to False then it will be false for every procedure until it is not set to TRUE,* *Try to execute below procedure after and before commenting Third Last Line **J*** * * *Sub FillByloop()* *Dim lngI As Long* *Application.ScreenUpdating = False* *For lngI = 1 To 1* *[a1] = lngI* *Next* *Application.ScreenUpdating = True* *Call FillByloop2* *End Sub* * * * * *Sub FillByloop2()* *Dim lngI As Long* *For lngI = 1 To 1* *[a1] = lngI* *Next * *End Sub* * * *===* *Enjoy **J*** *===* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde *Sent:* 20 October 2012 12:01 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ ** ** Thanks to all Just one question for Knowledge I run the script by both way 1.By Making true at the end 2.Without making true at end I could not notice any difference. So please can any one explain me What is the purpose of making true at end? Aging I ma repeating this is just for Knowledge. Regards Shrinivas On Fri, Oct 19, 2012 at 6:29 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *But also make them TRUE at end of code * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde *Sent:* 19 October 2012 5:25 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Dear Both, Very very thanks for solution. Regards Shrinivas On Fri, Oct 19, 2012 at 1:19 PM, v...@vabs.in wrote: Hi Just put Application.Screenupdating = False Rgds// Vabs Sent on my BlackBerry® from Vodafone -- *From: *Shrinivas Shevde shrinivas...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 19 Oct 2012 12:29:55 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Dear Group member, I wrote small macro which works fine. But when I run macro it shows all action i.e everything ishappening in front of user which I dont want . I want that when I run macro Worksheet should be steady and all actions should happen at backend. How to do it please let me know. Is ther any extra code needs to write. -- Shrini -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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)
$$Excel-Macros$$ Re: Good Laptop to Buy..
Hello, The configuration is oke , video card should be separated not integrated and as for company that you should choose , i rather opt for Asus ,Toshiba. On Saturday, October 20, 2012 3:03:22 PM UTC+3, Vabz wrote: Hi, All I want to buy good laptop for my personal use, pl experts suggest on it. Min. Configuration required: 4GB Ram, Intel I5, 1TB HD.. It should be value for money also.. Which company to go for .. Thanks a lot.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: Good Laptop to Buy..
Wooww! Gud input.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: CoRe neculae.vale...@gmail.com Date: Mon, 22 Oct 2012 04:17:49 To: excel-macros@googlegroups.com Cc: v...@vabs.in Subject: Re: Good Laptop to Buy.. Hello, The configuration is oke , video card should be separated not integrated and as for company that you should choose , i rather opt for Asus ,Toshiba. On Saturday, October 20, 2012 3:03:22 PM UTC+3, Vabz wrote: Hi, All I want to buy good laptop for my personal use, pl experts suggest on it. Min. Configuration required: 4GB Ram, Intel I5, 1TB HD.. It should be value for money also.. Which company to go for .. Thanks a lot.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$
Hi Right click on your module, under protection you can opt for setting password. Rgds//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Shrinivas Shevde shrinivas...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 16:46:55 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dear Tem members, can anyone explain me how to protect the code Regards Shrinivas On Mon, Oct 22, 2012 at 4:44 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear Rajan Thanks Regards Shrinivas On Sat, Oct 20, 2012 at 2:53 PM, Rajan_Verma rajanverma1...@gmail.comwrote: * * *Here are a simplest example,* * * *You can use this code to understand the thing about screen updating True/False* * * *ScreenUpdating is Application Property , so it works on application level, means once it set to False then it will be false for every procedure until it is not set to TRUE,* *Try to execute below procedure after and before commenting Third Last Line **J*** * * *Sub FillByloop()* *Dim lngI As Long* *Application.ScreenUpdating = False* *For lngI = 1 To 1* *[a1] = lngI* *Next* *Application.ScreenUpdating = True* *Call FillByloop2* *End Sub* * * * * *Sub FillByloop2()* *Dim lngI As Long* *For lngI = 1 To 1* *[a1] = lngI* *Next * *End Sub* * * *===* *Enjoy **J*** *===* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde *Sent:* 20 October 2012 12:01 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ ** ** Thanks to all Just one question for Knowledge I run the script by both way 1.By Making true at the end 2.Without making true at end I could not notice any difference. So please can any one explain me What is the purpose of making true at end? Aging I ma repeating this is just for Knowledge. Regards Shrinivas On Fri, Oct 19, 2012 at 6:29 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *But also make them TRUE at end of code * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde *Sent:* 19 October 2012 5:25 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Dear Both, Very very thanks for solution. Regards Shrinivas On Fri, Oct 19, 2012 at 1:19 PM, v...@vabs.in wrote: Hi Just put Application.Screenupdating = False Rgds// Vabs Sent on my BlackBerry® from Vodafone -- *From: *Shrinivas Shevde shrinivas...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 19 Oct 2012 12:29:55 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Dear Group member, I wrote small macro which works fine. But when I run macro it shows all action i.e everything ishappening in front of user which I dont want . I want that when I run macro Worksheet should be steady and all actions should happen at backend. How to do it please let me know. Is ther any extra code needs to write. -- Shrini -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise,
Re: $$Excel-Macros$$ Formula Needed !!!!!
Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal abhishekagarwal...@gmail.comwrote: Dear Shaikh Iqbal Please find the attachment for the same On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal iqbal.hp...@gmail.comwrote: Dear Exports, Need help in attached file. Shaikh Iqbal -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Formula Needed !!!!!
use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya amreshkushw...@gmail.comwrote: PFA File On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal abhishekagarwal...@gmail.com wrote: Dear Shaikh Iqbal Please find the attachment for the same On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Dear Exports, Need help in attached file. Shaikh Iqbal -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
$$Excel-Macros$$ countif in hidden rows
Dear Experts, kindly provide me countif formula for hidden rows, i triend to use subtotal but could fine the way,kindly provide me formula. From: aamirshahza...@gmail.com Date: Mon, 22 Oct 2012 17:11:03 +0500 Subject: Re: $$Excel-Macros$$ Formula Needed ! To: excel-macros@googlegroups.com use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya amreshkushw...@gmail.com wrote: PFA File On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal abhishekagarwal...@gmail.com wrote: Dear Shaikh Iqbal Please find the attachment for the same On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Dear Exports, Need help in attached file. Shaikh Iqbal -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ countif in hidden rows
Hi, For countif you have to use 102 with subtotal formula. Rgds//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: danial mansoor danial_...@hotmail.com Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 13:50:58 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ countif in hidden rows Dear Experts, kindly provide me countif formula for hidden rows, i triend to use subtotal but could fine the way,kindly provide me formula. From: aamirshahza...@gmail.com Date: Mon, 22 Oct 2012 17:11:03 +0500 Subject: Re: $$Excel-Macros$$ Formula Needed ! To: excel-macros@googlegroups.com use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya amreshkushw...@gmail.com wrote: PFA File On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal abhishekagarwal...@gmail.com wrote: Dear Shaikh Iqbal Please find the attachment for the same On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Dear Exports, Need help in attached file. Shaikh Iqbal -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles.
$$Excel-Macros$$ Adding OR in between numbers using macro
hi, I have to add one variable OR in between numbers I have attached the excel sheet. Kindly do the needful. Input : 1231 , 1234 , 12345 , 4342 Output 1231 OR 1234 OR 12345 OR 4342 -- Vignesh .S.R -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. numbering.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ countif in hidden rows
u did not get it,sir in subtotal we don't have option of Counting things with conditions as we do with countif,so i want a way to count with condition with hidden rows. to make it more elaborate when i use countif with hidden rows it counts everything including hidden and unhidden rows but i want to count only UNHIDDEN data not hidden so i need formula for that so kindly provide me that formula. Subject: Re: $$Excel-Macros$$ countif in hidden rows To: excel-macros@googlegroups.com From: v...@vabs.in Date: Mon, 22 Oct 2012 14:37:32 + Hi, For countif you have to use 102 with subtotal formula. Rgds//Vabs Sent on my BlackBerry® from VodafoneFrom: danial mansoor danial_...@hotmail.com Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 13:50:58 +To: excel-macros@googlegroups.comReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ countif in hidden rows Dear Experts, kindly provide me countif formula for hidden rows, i triend to use subtotal but could fine the way,kindly provide me formula. From: aamirshahza...@gmail.com Date: Mon, 22 Oct 2012 17:11:03 +0500 Subject: Re: $$Excel-Macros$$ Formula Needed ! To: excel-macros@googlegroups.com use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya amreshkushw...@gmail.com wrote: PFA File On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal abhishekagarwal...@gmail.com wrote: Dear Shaikh Iqbal Please find the attachment for the same On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Dear Exports, Need help in attached file. Shaikh Iqbal -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a
Re: $$Excel-Macros$$ countif in hidden rows
Hi PFA Rgds//Vabs On Monday, October 22, 2012 8:14:41 PM UTC+5:30, danial mansoor wrote: u did not get it,sir in subtotal we don't have option of Counting things with conditions as we do with countif,so i want a way to count with condition with hidden rows. to make it more elaborate when i use countif with hidden rows it counts everything including hidden and unhidden rows but i want to count only UNHIDDEN data not hidden so i need formula for that so kindly provide me that formula. -- Subject: Re: $$Excel-Macros$$ countif in hidden rows To: excel-...@googlegroups.com javascript: From: v...@vabs.in javascript: Date: Mon, 22 Oct 2012 14:37:32 + Hi, For countif you have to use 102 with subtotal formula. Rgds//Vabs Sent on my BlackBerry® from Vodafone -- *From: * danial mansoor dania...@hotmail.com javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Mon, 22 Oct 2012 13:50:58 + *To: *excel-...@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Subject: *$$Excel-Macros$$ countif in hidden rows Dear Experts, kindly provide me countif formula for hidden rows, i triend to use subtotal but could fine the way,kindly provide me formula. -- From: aamirsh...@gmail.com javascript: Date: Mon, 22 Oct 2012 17:11:03 +0500 Subject: Re: $$Excel-Macros$$ Formula Needed ! To: excel-...@googlegroups.com javascript: use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya amreshk...@gmail.comjavascript: wrote: PFA File On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal iqbal...@gmail.comjavascript: wrote: Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal abhisheka...@gmail.comjavascript: wrote: Dear Shaikh Iqbal Please find the attachment for the same On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal iqbal...@gmail.comjavascript: wrote: Dear Exports, Need help in attached file. Shaikh Iqbal -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ Adding OR in between numbers using macro
USE THIS UDF Function concatenate_nonblanks(x As Range, spl As String) Dim cell As Range Dim rsl As String For Each cell In x If cell vbNullString Then rsl = rsl spl cell End If Next concatenate_nonblanks = Right(rsl, Len(rsl) - Len(spl)) End Function in cell b8 type = =concatenate_nonblanks(A2:A6, OR ) On Mon, Oct 22, 2012 at 8:09 PM, Vignesh S R srvigneshs...@gmail.comwrote: hi, I have to add one variable OR in between numbers I have attached the excel sheet. Kindly do the needful. Input : 1231 , 1234 , 12345 , 4342 Output 1231 OR 1234 OR 12345 OR 4342 -- Vignesh .S.R -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ ONLINE .NET TRAINING
HI, PLEASE FIND THE BELOW LINK FOR .NET ONLINE TRAINING AND PROJECT SUPPORT. http://onlinenettrainings.blogspot.com/ PLEASE FEEL FREE TO CONTACT FOR ANY QUERIES TO BELOW MAIL ID rudrajayku...@gmail.com THANK YOU AJAY KUMAR -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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) Dont post a question in the thread of another member. 3) Dont 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Dont ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ ONLINE .NET TRAINING
Dear Ayush, Pls ban this email id Sent from BlackBerry® on Airtel -Original Message- From: mytrani...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 17:33:36 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ ONLINE .NET TRAINING HI, PLEASE FIND THE BELOW LINK FOR .NET ONLINE TRAINING AND PROJECT SUPPORT. http://onlinenettrainings.blogspot.com/ PLEASE FEEL FREE TO CONTACT FOR ANY QUERIES TO BELOW MAIL ID rudrajayku...@gmail.com THANK YOU AJAY KUMAR -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ MsgBox Query
Dears, Find enclosed above attachemnt I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX Awiting... Sajid Memon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. MSGBOX.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Good Laptop to Buy..
Hi, U Can buy Acer Aspire S3-I5.. Regard Manoj On Mon, Oct 22, 2012 at 4:49 PM, v...@vabs.in wrote: ** Wooww! Gud input.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -- *From: * CoRe neculae.vale...@gmail.com *Date: *Mon, 22 Oct 2012 04:17:49 -0700 (PDT) *To: *excel-macros@googlegroups.com *Cc: *v...@vabs.in *Subject: *Re: Good Laptop to Buy.. Hello, The configuration is oke , video card should be separated not integrated and as for company that you should choose , i rather opt for Asus ,Toshiba. On Saturday, October 20, 2012 3:03:22 PM UTC+3, Vabz wrote: Hi, All I want to buy good laptop for my personal use, pl experts suggest on it. Min. Configuration required: 4GB Ram, Intel I5, 1TB HD.. It should be value for money also.. Which company to go for .. Thanks a lot.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ MsgBox Query
Use this - MsgBox Sheets(Sheet1).Range(A1) HTH On Tue, Oct 23, 2012 at 10:40 AM, SAJID MEMON sajidwi...@hotmail.comwrote: Dears, Find enclosed above attachemnt I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX Awiting... Sajid Memon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: Text need in different collume
Dear Expert, I have data witch has Text and Number i want to do saperate text and number in next collume. man25oj kuma112r ro444ha25n 25s26on7 Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.