RE: $$Excel-Macros$$ Excel - Cell color actions
You need to make a color mapping and can use vlookup.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of siti Vi Sent: Dec/Fri/2011 10:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Cell color actions I have Color-Index-Number ( 1 to 56) for excel pallete What number for RED, what Number for Blue ? etc Please full fill the list (name of color) (attached) Based on you Color Naming, we 'll create a Custom function for you color color index color name, in english where is red, where is blue ? 1 where is yellow ? E.t.c. 2 please full fill D Column (D3:D58) = 56 color name 3 based on your color-maing in D column 4 we shall make a custom worksheet function for you 5 6 7 8 54 55 56 On Thu, Dec 29, 2011 at 12:58 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Team, I would like to know the options/code for performing some actions based on the cell interior color. for example if cell A1 is of Green color I would like to print Green Color text in B1 if cell A1 is of Red color I would like to print Red Color text in B1 if cell A1 is of Yellow color I would like to print Yellow Color text in B1 Thank you in advance for the help. Thanks, Amar -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ To Extract a text with Conditions
Great From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Haseeb Avarakkan Sent: Dec/Fri/2011 09:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions Try this Array Formula, =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(IFERROR(MATCH(MID(A6,ROW(A$1:A$50)*4- 3,3),IF(MID(A6,ROW(A$1:A$50)*4-3,3)=,A,MID(A6,ROW(A$1:A$50)*4-3,3)),0), ))) Copy down.. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ To Extract a text with Conditions
@ Haseeb, Nice :) -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Help
Hi, With the help of a helper column, a Pivot table would do the trick. PFA. Kris -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com BSE+Sensex.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Send Personalized emails in Lotus Notes
Hi I want to send emails with constant subject but with variable matter to people in the my list. I am using Lotus notes as email client. For example: Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com B3: q...@gmail.com B4: p...@gmail.com Can you help me create such code? Thanks in advance to all experts. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Send Personalized emails in Lotus Notes
Hi, See the link.. you can modify as per your requirement.. http://www.fabalou.com/VBandVBA/lotusnotesmail.asp -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 01:56 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Send Personalized emails in Lotus Notes Hi I want to send emails with constant subject but with variable matter to people in the my list. I am using Lotus notes as email client. For example: Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com B3: q...@gmail.com B4: p...@gmail.com Can you help me create such code? Thanks in advance to all experts. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Help
Hi Kris, you right..it is very complex with formula..I have to use Pivot table.itwill very easy.. Thanks Nikhil Shah On Fri, Dec 30, 2011 at 1:18 PM, Kris krishnak...@gmail.com wrote: Hi, With the help of a helper column, a Pivot table would do the trick. PFA. Kris -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ VBA Bignner
Hello Experts, I have sound knowledge of Excel but want to learn VBA as well. Please suggest me some material from where i can start learn Regards Raghav. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ VBA Bignner.
Rajan Sir, I have sound knowledge of Excel but want to learn VBA as well. Please suggest me some material from where i can start learn Regards Raghav. On Fri, Dec 30, 2011 at 2:00 PM, bhupendra singh raghav raghav.bhupen...@gmail.com wrote: Hi Rajan Sir, I have sound knowledge of Excel but want to learn VBA as well. Please suggest me some material from where i can start learn Regards Raghav. On Fri, Dec 30, 2011 at 1:58 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi, See the link.. you can modify as per your requirement.. http://www.fabalou.com/VBandVBA/lotusnotesmail.asp -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com ] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 01:56 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Send Personalized emails in Lotus Notes Hi I want to send emails with constant subject but with variable matter to people in the my list. I am using Lotus notes as email client. For example: Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com B3: q...@gmail.com B4: p...@gmail.com Can you help me create such code? Thanks in advance to all experts. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ VBA Bignner
Hi Raghav, Welcome to the Group. You can follow these site and blog to learn VBA and to better understand of Excel. If you want to read some book. You can download Many Free books on internet.. Please be in touch with Group :) www.ozgrid.com www.cpearson.com www.akoul.blogspot.com www.excelpoweruser.blogspot.com www.ozgrid.com akoul.posterous.com www.mrexcel.com www.contextures.com www.rondebruin.nl peltiertech.com chandoo.org www.mvps.org/links.html www.vbaexpress.com www.functionx.com www.freevbcode.com www.excelforum.com https://www.facebook.com/ExcelLover https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897 https://www.facebook.com/microsoftexcel https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2Fh=014d2; ref=ts http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-o nline/ -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Raghav Sent: Dec/Fri/2011 02:06 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ VBA Bignner Hello Experts, I have sound knowledge of Excel but want to learn VBA as well. Please suggest me some material from where i can start learn Regards Raghav. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes
Rajan Thanks for your reply. but sorry to say bro it's not working. On Dec 30, 1:28 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Hi, See the link.. you can modify as per your requirement.. http://www.fabalou.com/VBandVBA/lotusnotesmail.asp -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 01:56 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Send Personalized emails in Lotus Notes Hi I want to send emails with constant subject but with variable matter to people in the my list. I am using Lotus notes as email client. For example: Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com B3: q...@gmail.com B4: p...@gmail.com Can you help me create such code? Thanks in advance to all experts. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Send Personalized emails in Lotus Notes
You need to call this procedure with in another procedure with all parameters Sub sendMymail() SendNotesMail(Subject , attachment, ReceipentEmailID, bodytext, ,True) End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 02:53 To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes Rajan Thanks for your reply. but sorry to say bro it's not working. On Dec 30, 1:28 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Hi, See the link.. you can modify as per your requirement.. http://www.fabalou.com/VBandVBA/lotusnotesmail.asp -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 01:56 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Send Personalized emails in Lotus Notes Hi I want to send emails with constant subject but with variable matter to people in the my list. I am using Lotus notes as email client. For example: Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com B3: q...@gmail.com B4: p...@gmail.com Can you help me create such code? Thanks in advance to all experts. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- -- -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel - Cell color actions
Dear Both, Thank you for helping me out. I just understand that the interior's colors are actually coming from the conditional formatting, so I think the filtering / using of color property may not be helping, hence I'm switching to use the conditions which were used for conditional formatting. However, I'm not sure of the color which is appearing in my excel is same as which Siti has sent, hence unable to send you the excel file filled. However here is my main question again. I would like to include a comment in a new cell based on the interior color of the current cell. so irrespective of the colors, is there any way that I could use the interior color property to make the conditions or use the cell for further processing? Thanks in advance for the suggestions. Best regards, Amar On 30/12/2011, Rajan_Verma rajanverma1...@gmail.com wrote: You need to make a color mapping and can use vlookup.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of siti Vi Sent: Dec/Fri/2011 10:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Cell color actions I have Color-Index-Number ( 1 to 56) for excel pallete What number for RED, what Number for Blue ? etc Please full fill the list (name of color) (attached) Based on you Color Naming, we 'll create a Custom function for you color color index color name, in english where is red, where is blue ? 1 where is yellow ? E.t.c. 2 please full fill D Column (D3:D58) = 56 color name 3 based on your color-maing in D column 4 we shall make a custom worksheet function for you 5 6 7 8 54 55 56 On Thu, Dec 29, 2011 at 12:58 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Team, I would like to know the options/code for performing some actions based on the cell interior color. for example if cell A1 is of Green color I would like to print Green Color text in B1 if cell A1 is of Red color I would like to print Red Color text in B1 if cell A1 is of Yellow color I would like to print Yellow Color text in B1 Thank you in advance for the help. Thanks, Amar -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and
Re: $$Excel-Macros$$ Excel - Cell color actions
Try this : Sub AddCOmment() Dim rngCell As Range If rngCell.Interior.Color = YourCOlor Then rngCell.AddCOmment YourCommentText End If End Sub On Fri, Dec 30, 2011 at 3:20 PM, Kasireddy Amarender kassi.re...@gmail.comwrote: Dear Both, Thank you for helping me out. I just understand that the interior's colors are actually coming from the conditional formatting, so I think the filtering / using of color property may not be helping, hence I'm switching to use the conditions which were used for conditional formatting. However, I'm not sure of the color which is appearing in my excel is same as which Siti has sent, hence unable to send you the excel file filled. However here is my main question again. I would like to include a comment in a new cell based on the interior color of the current cell. so irrespective of the colors, is there any way that I could use the interior color property to make the conditions or use the cell for further processing? Thanks in advance for the suggestions. Best regards, Amar On 30/12/2011, Rajan_Verma rajanverma1...@gmail.com wrote: You need to make a color mapping and can use vlookup.. From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of siti Vi Sent: Dec/Fri/2011 10:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Cell color actions I have Color-Index-Number ( 1 to 56) for excel pallete What number for RED, what Number for Blue ? etc Please full fill the list (name of color) (attached) Based on you Color Naming, we 'll create a Custom function for you color color index color name, in english where is red, where is blue ? 1 where is yellow ? E.t.c. 2 please full fill D Column (D3:D58) = 56 color name 3 based on your color-maing in D column 4 we shall make a custom worksheet function for you 5 6 7 8 54 55 56 On Thu, Dec 29, 2011 at 12:58 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Team, I would like to know the options/code for performing some actions based on the cell interior color. for example if cell A1 is of Green color I would like to print Green Color text in B1 if cell A1 is of Red color I would like to print Red Color text in B1 if cell A1 is of Yellow color I would like to print Yellow Color text in B1 Thank you in advance for the help. Thanks, Amar -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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,
Re: $$Excel-Macros$$ Disable delete
Thanks its also useful to me Thanks Rajan. On Fri, Dec 30, 2011 at 10:09 AM, Prakash Gusain gusainprak...@gmail.comwrote: Thanks Asa it solved the issue! On Dec 27, 7:33 am, Asa Rossoff a...@lovetour.info wrote: Since deleting is done through the operating system, network (if applicable), and file system, This needs to be configured using file and network permissions. Here's an example advanced file permissions dialog under Windows 7, which allows specifically limiting delete file access: You can set permissions for entire network shares, entire folders, and for specific files. Permissions can be set for individual users, for specific groups of users, and for everyone. If the files are on a corporate network, usually you need to request the network administrators to change permissions. The simplest configuration is usually to have a specific network share for the project that most users have limited access to (can't delete, possibly even read-only access if appropriate) and you and/or the project developers have full access to. Asa -Original Message- From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Sunday, December 25, 2011 9:54 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Disable delete How can I disable the delete of an excel file? I don't want my user to delete the excel file kept at a location. Thanks in advance. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com image001.png 66KViewDownload image002.jpg 28KViewDownload -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes
Got a working code in our Jain brother's site. http://www.excelitems.com/2011/01/send-lotus-notes-email-vba-excel.html Thanks for your help though Rajan... On Dec 30, 2:28 pm, Rajan_Verma rajanverma1...@gmail.com wrote: You need to call this procedure with in another procedure with all parameters Sub sendMymail() SendNotesMail(Subject , attachment, ReceipentEmailID, bodytext, ,True) End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 02:53 To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes Rajan Thanks for your reply. but sorry to say bro it's not working. On Dec 30, 1:28 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Hi, See the link.. you can modify as per your requirement.. http://www.fabalou.com/VBandVBA/lotusnotesmail.asp -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 01:56 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Send Personalized emails in Lotus Notes Hi I want to send emails with constant subject but with variable matter to people in the my list. I am using Lotus notes as email client. For example: Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com B3: q...@gmail.com B4: p...@gmail.com Can you help me create such code? Thanks in advance to all experts. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- -- -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Auto create of sheet with new name in a sheet
Thanks krish its working great. Sandeep On 29 December 2011 19:22, Kris krishnak...@gmail.com wrote: Hi, Put this code in the 'Particular sheet' module. Right click on sheet name view code and paste the code there. Also I set the range D2 where you enter the name of the product. adjust this range in code if necessary. Private Sub Worksheet_Change(ByVal Target As Range) Const ProductNameCell As String = D2 '== adjust this range to suit If Target.Address(0, 0) ProductNameCell Then Exit Sub Dim wksNew As Worksheet On Error Resume Next Set wksNew = Worksheets(CStr(Target.Value)) If Err.Number = 0 Then MsgBox Sheet ' Target.Value ' already exists, vbCritical + vbInformation Application.EnableEvents = False Target.ClearContents Application.EnableEvents = True Exit Sub Else Err.Clear Worksheets.Add ActiveSheet.Name = Target.Value End If End Sub Kris -- Regards, Sandeep Kumar Chhajer. Ph. no: 07498171901 09339549906 Wish you all happy new Year 2011. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Auto create of sheet with new name in a sheet
Hi Please find the attached File.. It will also provide you automatically Hyperlinked index at the time of Worksheet Creation Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Application.ScreenUpdating = False If Target.Column = 1 And Target.Cells.Count = 1 And Target.Value Then ThisWorkbook.Worksheets.Add.Name = Target.Value Me.Hyperlinks.Add Target, , ' Target.Value '!A1 Me.Activate End If Err: If Err.Number 0 Then Err.Clear End If Application.ScreenUpdating = True End Sub Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: Dec/Thu/2011 05:55 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Auto create of sheet with new name in a sheet Dear excel advisor, I want a macro which create a sheet automatically if I add a new product name in a particular sheet with the name of the new product. And also want a condition validation which restrict user from inserting duplicate name where I insert the new product name. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerryR from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com CreateSheets.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ VBA Bignner
Thank Sir, I found this group very usefull. is good for beginners. On Fri, Dec 30, 2011 at 2:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Raghav, Welcome to the Group. You can follow these site and blog to learn VBA and to better understand of Excel. If you want to read some book. You can download Many Free books on internet.. Please be in touch with Group :) www.ozgrid.com www.cpearson.com www.akoul.blogspot.com www.excelpoweruser.blogspot.com www.ozgrid.com akoul.posterous.com www.mrexcel.com www.contextures.com www.rondebruin.nl peltiertech.com chandoo.org www.mvps.org/links.html www.vbaexpress.com www.functionx.com www.freevbcode.com www.excelforum.com https://www.facebook.com/ExcelLover https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897 https://www.facebook.com/microsoftexcel https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2Fh=014d2; ref=ts http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-o nline/ -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Raghav Sent: Dec/Fri/2011 02:06 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ VBA Bignner Hello Experts, I have sound knowledge of Excel but want to learn VBA as well. Please suggest me some material from where i can start learn Regards Raghav. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Need Unique list Function
hello sir, how to find extract unique list in a list thanks raghav. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ To Extract a text with Conditions
Yes,very nice Don Guillett SalesAid Software dguille...@gmail.com From: Haseeb Avarakkan Sent: Thursday, December 29, 2011 9:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions Try this Array Formula, =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(IFERROR(MATCH(MID(A6,ROW(A$1:A$50)*4-3,3),IF(MID(A6,ROW(A$1:A$50)*4-3,3)=,A,MID(A6,ROW(A$1:A$50)*4-3,3)),0),))) Copy down.. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Search Engine DOUBT
Not sure about this. Try this macro. You could assign this macro on a button as well for easy use. Sub kTest() Dim ka, k(), i As Long, n As Long, j As Long, c As Long Dim WhichColAs String, Cols(), x, SearchKey As String Const SearchCellAs String = E3 '== adjust to suit WhichCol = Application.InputBox(Enter the Column Name to Search, Search Col, For e.g. All or A or B or A,B, Type:=2) If WhichCol = False Then Exit Sub SearchKey = Trim(Range(CStr(SearchCell))) If Len(SearchKey) = 0 Then MsgBox Search text not found, vbInformation Exit Sub End If With Sheets(database) ka = Intersect(.UsedRange, .Range(a:g)) End With If InStr(1, WhichCol, ,) Then x = Split(WhichCol, ,) For i = 0 To UBound(x) ReDim Preserve Cols(0 To i) Cols(i) = Cells(1, x(i)).Column Next ElseIf LCase$(WhichCol) = all Then For i = 1 To UBound(ka, 2) ReDim Preserve Cols(0 To i - 1) Cols(i - 1) = i Next Else ReDim Preserve Cols(0 To 0) Cols(0) = Cells(1, WhichCol).Column End If ReDim k(1 To UBound(ka, 1), 1 To UBound(ka, 2)) For i = 2 To UBound(ka, 1) If Len(ka(i, 1)) Then For j = LBound(Cols) To UBound(Cols) If InStr(1, ka(i, Cols(j)), SearchKey, 1) Then n = n + 1 For c = 1 To UBound(ka, 2) k(n, c) = ka(i, c) Next Exit For End If Next End If Next If n Then [c8].Resize(i, c - 1).ClearContents [c8].Resize(n, UBound(k, 2)) = k Else MsgBox No record(s) found, vbInformation Exit Sub End If End Sub Kris -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel - Cell color actions
Hello Amar, As you said colors are changing through CF, check is the conditions TRUE or FALSE, then you can assign the values, if it is true. If you can share a dummy file or your CF condition to the group, it would be helpful. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$dividing my data set in 70-30 Ratio
Try this.use this macro Sub Test() Dim RowCount As Integer Dim S As Integer Dim T As Integer LR = Cells(Rows.Count, A).End(xlUp).Row RowCount = LR S = Round(RowCount * 70 / 100, 0) T = Application.WorksheetFunction.RoundUp(RowCount * 30 / 100, 0) Range(A1).Resize(S).Select Selection.Copy Range(B1).Select ActiveSheet.Paste Range(A1).Resize(T).Select Selection.Copy Range(C1).Select ActiveSheet.Paste End Sub sample data 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 200 213.333 221.9047619 Paste this in the first column and try running the macro. See if it helps.on the same basic ground that I have used, u can modiify the macro as well..Thank you !! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$dividing my data set in 70-30 Ratio
Try this Code: Sub DividData() Dim wksSheet As Worksheet Application.ScreenUpdating = 0 With ThisWorkbook Set wksSheet = ActiveSheet wksSheet.Range(A1:A Int((wksSheet.UsedRange.Rows.Count * 70) / 100)).EntireRow.Copy .Worksheets.Add.Name = 70% .ActiveSheet.Paste wksSheet.Range(A Int((.ActiveSheet.UsedRange.Rows.Count * 70) / 100) + 1 :A wksSheet.UsedRange.Rows.Count).EntireRow.Copy .Worksheets.Add.Name = 30% .ActiveSheet.Paste End With wksSheet.Activate Application.CutCopyMode = False Application.ScreenUpdating = 1 End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rohan Sent: Dec/Fri/2011 11:51 To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$dividing my data set in 70-30 Ratio Try this.use this macro Sub Test() Dim RowCount As Integer Dim S As Integer Dim T As Integer LR = Cells(Rows.Count, A).End(xlUp).Row RowCount = LR S = Round(RowCount * 70 / 100, 0) T = Application.WorksheetFunction.RoundUp(RowCount * 30 / 100, 0) Range(A1).Resize(S).Select Selection.Copy Range(B1).Select ActiveSheet.Paste Range(A1).Resize(T).Select Selection.Copy Range(C1).Select ActiveSheet.Paste End Sub sample data 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 200 213.333 221.9047619 Paste this in the first column and try running the macro. See if it helps.on the same basic ground that I have used, u can modiify the macro as well..Thank you !! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Make String From Range without any Loop
Hi Group, Want to share a useful method on group to make a delimiter separated list without any loop after taking Input Range of One Column of One Row, it can work on 255 Cells. Application.Transpose need to be used once if Data is Vertical and if data is horizontal its need to be used Twice.. JOIN(YourRange,Delimeter) YourRange = any Row and Column (Till 255 Cells) Delimeter = Any Text seperater (e.g. ,,;,| etc) For Vertical Range /Column Range Sub MakeString() Dim strSting As String strSting = Join(Application.Transpose(Selection), ,) Debug.Print strSting End Sub For Horizontal Range/Row Range Sub MakeString() Dim strSting As String strSting = Join(Application.transpose(Application.Transpose(Selection)), ,) Debug.Print strSting End Sub -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ copy data to new work book
Dear Chandra, You can also use this one.. Range(d5:d10).Copy Workbooks.Add Activeworkbook.Sheets(1).Range(a1).Select Activesheet.paste On Wed, Dec 28, 2011 at 2:30 PM, chandra sekaran duraichan...@gmail.comwrote: Dear sir i have code for copy past like this Range(d5:d10).Copy Workbooks.Add WorkSheet(1).Range(a1) but this is not working what i have missed out regards chandru -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need Unique list Function
Dear Bhupendra, See attached sheet, i hope it will help to u. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Dec 30, 2011 at 3:02 PM, bhupendra singh raghav raghav.bhupen...@gmail.com wrote: hello sir, how to find extract unique list in a list thanks raghav. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Sample_Sheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: Hiding all excel functions
Press ctrl+A, then ctrl+1 then Protection-Click on Hidden then protect the sheet. On Wed, Dec 28, 2011 at 4:34 PM, EGMono egm...@gmail.com wrote: Set Toolbars visible to false, then set them back to true when the workbook loses focus or quits. On Dec 27, 1:53 pm, treboryevrah j...@consultageek.com wrote: How do I create a stand alone application out of an excel worksheet. That is all tab lists up top ie home insert pagelayout etc. needs to not be displayed. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ To Extract a text with Conditions
Excellent Haseeb On Fri, Dec 30, 2011 at 9:22 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Try this *Array Formula*, =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(IFERROR(MATCH(MID(A6,ROW(A$1:A$50)*4-3,3),IF(MID(A6,ROW(A$1:A$50)*4-3,3)=,A,MID(A6,ROW(A$1:A$50)*4-3,3)),0),))) Copy down.. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Disable delete
Dear Prakash, Please use attached sheet to disable any key. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Dec 26, 2011 at 11:23 AM, Prakash Gusain gusainprak...@gmail.comwrote: How can I disable the delete of an excel file? I don't want my user to delete the excel file kept at a location. Thanks in advance. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com How can disable Short cut key in excel.docx Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Re: $$Excel-Macros$$ Make String From Range without any Loop
Good one Rajan.. On Sat, Dec 31, 2011 at 12:35 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Group, ** ** Want to share a useful method on group to make a delimiter separated list without any loop after taking Input Range of One Column of One Row, it can work on 255 Cells. Application.Transpose need to be used once if Data is Vertical and if data is horizontal its need to be used Twice.. ** ** *JOIN(YourRange,Delimeter)* *YourRange = any Row and Column (Till 255 Cells)* *Delimeter = Any Text seperater (e.g. “,”,”;”,”|” etc)* ** ** For Vertical Range /Column Range Sub MakeString() Dim strSting As String strSting = Join(Application.Transpose(Selection), ,) Debug.Print strSting End Sub For Horizontal Range/Row Range Sub MakeString() Dim strSting As String strSting = Join(Application.transpose(Application.Transpose(Selection)), ,) Debug.Print strSting End Sub ** ** -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ copy data to new work book
HI, Tryi this : Sub CopyDatatoNewWorkbook() Dim wbkNew As Workbook Set wbkNew = Workbooks.Add ThisWorkbook.ActiveSheet.UsedRange.Copy wbkNew.Worksheets(1).Range(A1) End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Dec/Sat/2011 07:05 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ copy data to new work book Dear Chandra, You can also use this one.. Range(d5:d10).Copy Workbooks.Add Activeworkbook.Sheets(1).Range(a1).Select Activesheet.paste On Wed, Dec 28, 2011 at 2:30 PM, chandra sekaran duraichan...@gmail.com wrote: Dear sir i have code for copy past like this Range(d5:d10).Copy Workbooks.Add WorkSheet(1).Range(a1) but this is not working what i have missed out regards chandru -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Need Unique list Function
See the attached file.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Dec/Sat/2011 07:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Unique list Function Dear Bhupendra, See attached sheet, i hope it will help to u. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Fri, Dec 30, 2011 at 3:02 PM, bhupendra singh raghav raghav.bhupen...@gmail.com wrote: hello sir, how to find extract unique list in a list thanks raghav. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com UniqueListByFunction.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
RE: $$Excel-Macros$$ Disable delete
Hi Noorain.. Query is how to prevent files to be delete from folders?? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Dec/Sat/2011 09:48 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Disable delete Dear Prakash, Please use attached sheet to disable any key. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Mon, Dec 26, 2011 at 11:23 AM, Prakash Gusain gusainprak...@gmail.com wrote: How can I disable the delete of an excel file? I don't want my user to delete the excel file kept at a location. Thanks in advance. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ How to create *.xla format file
Dear experts, Please know me, how to create a *.xla format file of macro Regards Ashish Bhalara 9624111822 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ How to create *.xla format file
Hi.. If you will save your file in .xla , Excel will Cerate Excel -2003 Add-ins, To make an add-ins you need to have atleast on macro in your workbook.. And by double click on this file you can add this to your application, your macro will at application level. For more details Visit this page.. http://www.ozgrid.com/VBA/excel-add-in-create.htm Regards Rajan Verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Dec/Sat/2011 12:24 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to create *.xla format file Dear experts, Please know me, how to create a *.xla format file of macro Regards Ashish Bhalara 9624111822 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ To Extract a text with Conditions
Hi All, I am sorry, I didn't access my mail yesterday, Thanks to all of you for your replies, @Rajan, I have checked your comparison, don,yours, Kris also Haseeb's, Hasseb's Kris's giving same result, but as per your solution in some cells it results blank cells, I dont know whether I am doing anything wrong or not? if ignore this error yours and Don's will get same result. In all these four solutions Kris's and Haseeb's provide more accurate result. Still there is one thing should be modified on this, as in case of (Cell ref:A109) DMS-BAH-DAM-BAH-DMM result should be 'DAM' Hope you could do some modifications Once again thanks all of you guys for such a great helps. On Sat, Dec 31, 2011 at 5:44 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Excellent Haseeb On Fri, Dec 30, 2011 at 9:22 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Try this *Array Formula*, =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(IFERROR(MATCH(MID(A6,ROW(A$1:A$50)*4-3,3),IF(MID(A6,ROW(A$1:A$50)*4-3,3)=,A,MID(A6,ROW(A$1:A$50)*4-3,3)),0),))) Copy down.. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ To Extract a text with Conditions
My Function is working on those Destinations which are listed in FinalDestination Column , if the Keyword is not found in the list FinalDestination.. Result will be blank.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Dec/Sat/2011 01:00 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions Hi All, I am sorry, I didn't access my mail yesterday, Thanks to all of you for your replies, @Rajan, I have checked your comparison, don,yours, Kris also Haseeb's, Hasseb's Kris's giving same result, but as per your solution in some cells it results blank cells, I dont know whether I am doing anything wrong or not? if ignore this error yours and Don's will get same result. In all these four solutions Kris's and Haseeb's provide more accurate result. Still there is one thing should be modified on this, as in case of (Cell ref:A109) DMS-BAH-DAM-BAH-DMM result should be 'DAM' Hope you could do some modifications Once again thanks all of you guys for such a great helps. On Sat, Dec 31, 2011 at 5:44 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Excellent Haseeb On Fri, Dec 30, 2011 at 9:22 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Try this Array Formula, =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(IFERROR(MATCH(MID(A6,ROW(A$1:A$50)*4- 3,3),IF(MID(A6,ROW(A$1:A$50)*4-3,3)=,A,MID(A6,ROW(A$1:A$50)*4-3,3)),0), ))) Copy down.. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ To Extract a text with Conditions
Hi Rajan, what i mentioned in Final Destination column was required result, What I need is i have to extract those codes from Column A, logic I had mentioned in my first post. On Sat, Dec 31, 2011 at 10:33 AM, Rajan_Verma rajanverma1...@gmail.comwrote: My Function is working on those Destinations which are listed in FinalDestination Column , if the Keyword is not found in the list FinalDestination.. Result will be blank.. ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Excel_Lover *Sent:* Dec/Sat/2011 01:00 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ To Extract a text with Conditions ** ** Hi All, I am sorry, I didn't access my mail yesterday, Thanks to all of you for your replies, @Rajan, I have checked your comparison, don,yours, Kris also Haseeb's, Hasseb's Kris's giving same result, but as per your solution in some cells it results blank cells, I dont know whether I am doing anything wrong or not? if ignore this error yours and Don's will get same result. In all these four solutions Kris's and Haseeb's provide more accurate result. Still there is one thing should be modified on this, as in case of (Cell ref:A109) DMS-BAH-DAM-BAH-DMM result should be 'DAM' Hope you could do some modifications Once again thanks all of you guys for such a great helps. On Sat, Dec 31, 2011 at 5:44 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Excellent Haseeb ** ** On Fri, Dec 30, 2011 at 9:22 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Try this *Array Formula*, =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(IFERROR(MATCH(MID(A6,ROW(A$1:A$50)*4-3,3),IF(MID(A6,ROW(A$1:A$50)*4-3,3)=,A,MID(A6,ROW(A$1:A$50)*4-3,3)),0),))) Copy down.. ___ HTH, Haseeb ** ** -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ ** ** -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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