Re: $$Excel-Macros$$ copy paste in reverse order
Hi Amit, How abt a keyboard shortcut for this, Select the second row ''Cntrl X'' go to the first row and press Cntrl + On Wed, Mar 21, 2012 at 8:50 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amit, Pls check attached sheet. On Wed, Mar 21, 2012 at 7:49 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Sorry but this VBA is not working ** ** Can we have some very simple command like Alt+E+S+V+E which is used to transpose while special pasting! ** ** Best Regards, Amit ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* 20 March 2012 11:44 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ copy paste in reverse order ** ** Dear Amit, you can also try through VBA.. Sub reverse_order() Dim i, rw As Integer rw = Cells(Rows.Count, A).End(xlUp).Row For i = 1 To rw Cells(i, B).Value = Cells((rw + 1) - i, A) Next i End Sub See attached sheet. On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Hi, Is there any formula to copy data from say 2 rows say 1 2 paste them in reverse order. Data of 1st row will move to 2nd of 2nd row to first.. Best Regards, Amit ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company
Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari
Congrats noorain On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Feb'12 He has posted 156 posts in Feb'12 and helped many people through his expertise. He has been consistent contributor to this excel forum but has acheived this recognition for third time. *About Noorain Ansari :* [image: noorain.jpg] Noorain is a great poet and keep sharing his thoughts on different topics throgh cool poems. Professionally, he is a Excel aficionado and presently working as senior business analyst in One97 Communication Ltd. He is a MS excel - vba expert and keep sharing his thoughts with this forum. You can follow his blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com www.noorain-ansari.blogspot.com *Noorain, Many thanks for all your great support to group. Keep it up* *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up !! ** *Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com noorain.jpg
RE: $$Excel-Macros$$ Help: VBA code for RGB values
Thank you so much for this, it is as perfect as I wanted. One Love. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Sunday, March 11, 2012 12:14 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help: VBA code for RGB values http://www.cpearson.com/excel/colors.aspx http://www.cpearson.com/excel/colors.aspx see att Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Janet Dickson mailto:janetdicks...@gmail.com Sent: Saturday, March 10, 2012 6:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help: VBA code for RGB values Hi All, I have attached a file to show my challenge. The file shows one column with colors in cells and second column empty, but I want to add RGB Values automatically using VBA. Help please. cheers -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Match text to a list
The code you supply works perfectly except for one issue. I am checking a column to see if I have run a report before and therefore the check for the match. The problem is I have one report marked AA and another marked A. If I have run the report AA before then when I run the report A, the code is indicating that the report has already been run. It seems to be seeing the AA as a match On Sat, Mar 10, 2012 at 7:25 PM, dguillett1 dguille...@gmail.com wrote: isnumber is based on the SEARCH returning same Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Brian brianfosterbl...@gmail.com *Sent:* Saturday, March 10, 2012 10:53 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Match text to a list Thank you Kris, your solution works perfectly. I was just wondering why you use IsNumber when it is actually text I am looking for? I mean it works but I am just curious. On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote: I am using Excel 2007 In cell D18 I have some text. I need the VBA to check if this text appears in the list in Cells L6:L27 If it does it then exits the sub otherwise it must do something else. Can anyone help with this code. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Match text to a list
Hi Replace Flg = Evaluate(ISNUMBER(LOOKUP(9.999E+307,SEARCH(D18,L6:L27 with Flg = Evaluate(ISNUMBER(MATCH(D18,L6:L27,0))) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ copy data from excel to Notepad using VBA code
Team, I have data in excel sheet column E, this data should paste in new notepad after that column E copymode must be normal. (Cutcopymode=false) can you please provide code for this Thanks in advance... Regards, Naresh V -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Macro for Insert a line for missing serial numbers.
Dear all, Please find my attachment ( I know asking question in this way is a violation of our forum rule but sorry I don't have data card to copy the queries from excel) Thanking you in advance. Sandeep Chhajer. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com FOR MACRO.xlsx Description: Binary data
Re: $$Excel-Macros$$ copy data from excel to Notepad using VBA code
Dear Naresh, pls try it.. Sub copyPastedata_in_Notepad() With Application Selection.Copy Shell notepad.exe, 3 SendKeys ^v VBA.AppActivate .Caption .CutCopyMode = False End With End Sub On Wed, Mar 21, 2012 at 8:16 PM, Naresh V naresh.veerabo...@gmail.comwrote: Team, I have data in excel sheet column E, this data should paste in new notepad after that column E copymode must be normal. (Cutcopymode=false) can you please provide code for this Thanks in advance... Regards, Naresh V -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ copy data from excel to Notepad using VBA code
Thanks Mangesh, Please follow this excel macro group on regular basis and Start recording macros, and perform actions in the excel spreadsheet.The macro recorder will record macro. A lot of the lines may be superfluous, but you'll get a general perspective of how macro works. Slowly, you'll learn to read and differentiate between lines that actually do the task, and the superfluous ones. As an example, I recorded my action. I typed in a few lines is what I did. Code: Sub Macro1() Range(B3).Select ActiveCell.FormulaR1C1 = _ I am recording a macro to understand what the macro recorder records. Range(B4).Select ActiveCell.FormulaR1C1 = _ OK, I'll now write another text. I wonder what the macro recorder would have recorded now. Range(B5).Select ActiveCell.FormulaR1C1 = Oh well, been years since I did something like this. Range(D3).Select ActiveCell.FormulaR1C1 = _ Ok, just for the sake of it, I've scrolled to the right a bit and moved up to cell D3, to type this text. Range(D4).Select End Sub Now, a lot of those lines are superfluous. I could rewrite it like so. Code: Sub Macro2() Range(B3).Resize(3, 1).Value = _ Array(I am recording a macro to understand what the macro recorder records., _ OK, I'll now write another text. I wonder what the macro recorder would have recorded now., _ Oh well, been years since I did something like this.) Range(D3).Value = Ok, just for the sake of it, I've scrolled to the right a bit and moved up to cell D3, to type this text. End Sub So you see, just record macro, and eventually, the macro will teach you a lot of the syntax. Based on your understanding of how things work, you can then reduce the lines of code as I have did above. Note: Since Excel 2007 Chart actions are not recorded, and I can assure you a lot of others aren't (for reasons I do not want to pretend I know), if you want to go the learning path by recording, I recommend Excel 97-2003, or Excel 2010. http://www.excelfox.com/forum/f2/self-learn-excel-vba-193/ Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 21, 2012 at 10:25 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: Hi Noorain, You are simply awesome man !!! How many days you take to learn macros. Please tell me so that I could start to achieve something like you. Also provide me some tips for same. Kindly help. Mangesh On Wed, Mar 21, 2012 at 10:00 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: See attached sheet, -- On Wed, Mar 21, 2012 at 9:48 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Naresh, pls try it.. Sub copyPastedata_in_Notepad() With Application Selection.Copy Shell notepad.exe, 3 SendKeys ^v VBA.AppActivate .Caption .CutCopyMode = False End With End Sub On Wed, Mar 21, 2012 at 8:16 PM, Naresh V naresh.veerabo...@gmail.comwrote: Team, I have data in excel sheet column E, this data should paste in new notepad after that column E copymode must be normal. (Cutcopymode=false) can you please provide code for this Thanks in advance... Regards, Naresh V -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any
Re: $$Excel-Macros$$ cells shifting to Up!
Thanks Muneer and Lakshman Bro for your valuable appriciation. I am not any oxford, i am just a simple group member like you and feel very happy to help. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 21, 2012 at 10:31 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: I AGREE TOOO *From:* Mohammed Muneer mmun...@ccc.com.qa *To:* excel-macros@googlegroups.com *Sent:* Tuesday, March 20, 2012 7:51 PM *Subject:* RE: $$Excel-Macros$$ cells shifting to Up! ** Dear Sir, Mr. Don really amaazing! I am not getting words to praise u’r talent…. Again again again thanx…. I am thankful to u both Mr. Noor you Mr. Don U people r OXFORD of our group…… I think u unearthed all that are not seen by this generation…. My outlook page is not enough to praise u people…… Regards, Muneer, CC…. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *dguillett1 *Sent:* Tuesday, March 20, 2012 4:36 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ cells shifting to Up! A small primer in the use of specialcells Sub DeleteBlanksUsingSpecialCellsSAS() Cells.SpecialCells(xlBlanks).Delete End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Mohammed Muneer mmun...@ccc.com.qa *Sent:* Tuesday, March 20, 2012 2:13 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ cells shifting to Up! Dear Noor Good Morning, Still I did not understand the procedure, please again I repeat the same thing I want to shift the cells below to top to form a single line order. Please any code that can help me….. I write one but it doesn’t seem to work properly. *Sub Button3_Click()* Worksheets(Sheet1).activate Range(A1:d1).Select Range(range1_2).activate Worksheets(Sheet1).Range(A1:d4).FillUp End Sub Regards, Muneer, CC… *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* Monday, March 19, 2012 8:29 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ cells shifting up! Dear Muneer, Please follow below step and see attached Sample sheet. Select A1:D4 Range Press ctrl+G-goto Special-Check Blank Press ctrl- and Shieft Cell Up On Mon, Mar 19, 2012 at 9:54 AM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Friends, I need to shift the cells up to bring them in one single line. TR1 1 2 3 TR1 1 2 3 this is my target… Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive
Re: $$Excel-Macros$$ Macro for Insert a line for missing serial numbers.
Dear Sandeep, Please explain more.. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 21, 2012 at 9:40 PM, chhajersand...@gmail.com wrote: Dear all, Please find my attachment ( I know asking question in this way is a violation of our forum rule but sorry I don't have data card to copy the queries from excel) Thanking you in advance. Sandeep Chhajer. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ email extraction from gmail
hi group, can you please advice me how to extract email id's from gmail or outlook using VBA Thanks Regards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink
hi all i am looking for some vba codes which will search html files (bases file names in the sheet) from specified locations and paste the path of the same file as hyperlink in the sheet Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ cells shifting to Up!
dear all Because of writing a VBA 2003 to 2007 by running the excel file. Details of the code is it to find information stored in the folder where the file excel 2003. I want to be by Chain version 2007 can not write code that would help me... password log modul 1 anirut.k fujikura production control -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: macro vba coding for html file search and paste the path as hyperlink
Can you send an example sheet ... or paste and example here On Thursday, March 22, 2012 12:13:35 AM UTC+5:30, Raj Mahapatra wrote: hi all i am looking for some vba codes which will search html files (bases file names in the sheet) from specified locations and paste the path of the same file as hyperlink in the sheet Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ HELP - MACRO TO INCREMENT A COLUMN IN FOR EACH UNIQUE VALUE IN ANOTHER COLUMN
Good day Group, I need some URGENT assistance with a MACRO TO INCREMENT A COLUMN IN FOR EACH UNIQUE VALUE IN ANOTHER COLUMN. Below is how it should work; I extracted some rows from the attached sheet *“*NBR ALL.xlsx*”*. For each* *unique text in column C there is a corresponding unique value in column H (Ranging from 0 to 32). Frequently I need to add new rows like in Figure 2 – that do not exist in “NBR ALL.xlsx “- and input in column H unique values for every unique text in column C .For instance, I pick in column C MNB001 in table 2 and then I look up in column H for all cells in column C in Table 1 containing MNB001 and report a unique value in column H of Table 2 (ranging from 0 to 32). Ojemeni Uzoma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com NBR.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Handling Large Blocks of Text in Excel
I have a number of different Excel front-ends that I use to extract information from various corporate database systems. One area of frustration arises when I am pulling large blocks of text from various note fields on various SQL servers.I often hit the Excel’s built in text limits for individual cells. As a work around I starting using Excel’s built in Text Boxes which works, however I am struggling with dynamically resizing these text boxes. I want to keep a certain width and adjust the length/height of the text boxes to accommodate varying amounts of text (this is required for printouts containing various information stored in cells + the entire text entry) OR If there are alternative method besides Text Boxes, I'm all ears... Thank you in advance for your help. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ cells shifting to Up!
dear all Because of writing a VBA 2003 to 2007 by running the excel file. Details of the code is it to find information stored in the folder where the file excel 2003. I want to be by Chain version 2007 can not write code that would help me... password log modul 1 anirut.k fujikura production control -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re:Help to find position of a particular number in a given data set
Hi, I need help to find position of a particular number in a given data set. Please refer to the table below. Fin. Inst. Rates in % A 10 B 11 C 12 D 11 E 6 F 9 G 8 H 8 I 9 J 7 In the above example, Rates are given for each financial institution. In descending order,the rate 12% is at the 1st position,11% is 2nd highest and so on. While using function LARGE or SMALL, we need to assign kth position to get the required result. I need to find (kth) position of given rate from the list, ignoring the duplicate items. Going back to the above example, 11% will be the second highest rate, 10% being the third highest rate and so on. Please let me know the function or combination of functions. Thank you for your help and time. Regards, Atul Patel H: 905 785 8324 C: 647 898 4074 atul_pate...@yahoo.com Good to know you ! Atul Patel H: 905 785 8324 C: 647 898 4074 atul_pate...@yahoo.com Good to know you ! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: connecting to an excel data file without opening the particular excel file
Hi Bheema, Please refer to the link below this should help you understand this in the future. http://office.microsoft.com/en-us/excel-help/create-edit-and-manage-connections-to-external-data-HA010167227.aspx On Tuesday, March 20, 2012 10:21:58 AM UTC+5:30, Bheema Shankar wrote: Dear Experts I am attaching two excel files. One is having Student data. I am having an userform in another excel file to prepare student marks information. Can I connect to the similar fields in the student data.xls without opening it from the student marks.xls by clicking UPDATE command button on the userform? waiting for your valuable replies. regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers.
Hi Sandeep, My code below assumes the following 1. The serial numbers are in column A 2. The Excel version you are using is 2007. 3. The code is good for 10,000 rows. Please modify if required. Sub Serial() Dim i As Long For i = 1 To 1 If Cells(i, 1) And Cells(i + 1, 1) Then If Cells(i + 1, 1) - Cells(i, 1) 1 Then Rows(i + 1 : i + 1).Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove i = i + 1 End If Else Exit For End If Next i End Sub On Wednesday, March 21, 2012 9:40:37 PM UTC+5:30, sandeep chhajer wrote: Dear all, Please find my attachment ( I know asking question in this way is a violation of our forum rule but sorry I don't have data card to copy the queries from excel) Thanking you in advance. Sandeep Chhajer. On Wednesday, March 21, 2012 9:40:37 PM UTC+5:30, sandeep chhajer wrote: Dear all, Please find my attachment ( I know asking question in this way is a violation of our forum rule but sorry I don't have data card to copy the queries from excel) Thanking you in advance. Sandeep Chhajer. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Pivot table
Hi Excel gurus, I have attached excel sheet consisting of pivot table, For second column in the attached sheet I need count. How to achieve this without using Macros. Thanks in advance. KrishDear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Pivot_table.xls Description: MS-Word document
$$Excel-Macros$$ Split text in cell
Hi Team, How to remove a words left text and right text of reference Please refer attachment. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Split a text.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Help with VBA Macro - Law Citations
I've tried searching for the answer to this question on google, but i'm not getting anywhere. I'm hoping some programming guru will see an answer where i cannot. I have a Word document that contains citations for documents. The citations would often be between other text that is not important to resolving the query: Eg. ..The appeal was allowed. Subsequently the Board in Huggins v The State *(2008) 73 WIR 420*, PC, in reviewing most of the authorities on the issue, reiterated the need for prosecuting counsel The area in bold is the citation. What I want is a macro that will take the citation, put it in a format that can be used to search an online database (I assume i'd need to know more about how the database handles the query and if there is an API or something, again..not very sure) and then open a browser to execute that query. I know that programs exist to do this very thing eg. Lexis for Microsoft Office and LexisCheck in the UK. Could anybody shed some light as to where I should start looking? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re:Help to find position of a particular number in a given data set
Sounds like homework Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Atul Patel Sent: Tuesday, March 20, 2012 4:24 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re:Help to find position of a particular number in a given data set Hi, I need help to find position of a particular number in a given data set. Please refer to the table below. Fin. Inst. Rates in % A 10 B 11 C 12 D 11 E 6 F 9 G 8 H 8 I 9 J 7 In the above example, Rates are given for each financial institution. In descending order,the rate 12% is at the 1st position,11% is 2nd highest and so on. While using function LARGE or SMALL, we need to assign kth position to get the required result. I need to find (kth) position of given rate from the list, ignoring the duplicate items. Going back to the above example, 11% will be the second highest rate, 10% being the third highest rate and so on. Please let me know the function or combination of functions. Thank you for your help and time. Regards, Atul Patel H: 905 785 8324 C: 647 898 4074 atul_pate...@yahoo.com Good to know you ! Atul Patel H: 905 785 8324 C: 647 898 4074 atul_pate...@yahoo.com Good to know you ! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....
Without seeing what you want with an example I can’t help Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Wednesday, March 21, 2012 5:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro. Thanks @ Ranjan, but I don't track it in MS-Access File, can you incorporate this codes for MS-Excel? Thanks @ dguillett1, but I'm not able to use the same code for Logout time tracking in a different column, can you please help me once again? @ Abdulgani Shaikh, I have attached the same file in .xls format. On Wed, Mar 21, 2012 at 11:12 PM, Rajan_Verma rajanverma1...@gmail.com wrote: It’s a old post on this group ,I have created a small tool to track punch in and punch out Time , hope it can help. ‘= Hi Lokesh, I am attaching Two files here.. 1). Save Access file at Shared Location. 2). In Code Module Replace Thisworkbook.Path with shared Path 3). Fill AllEmpID table in Database with EMPID for validation. ObjConnection.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ThisWorkbook.Path \table.accdb ; ‘= Regards Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: Mar/Wed/2012 03:17 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a small help, related to the Date and Time macro. Hi All, Need a small help from you all. I have attached a file with this mail. Now if you open the file you can see there is a button named Login, if you click on it, it will take the system time and date. There are two columns available, Name (Column A) and Login Time (Column B), now I want if the respective Column A is blank then it will not put the date and time in Column B, if there is a name in column A then only date and time will be captured in the column B, other wise it will give me a error message. If you have the code for the same then please provide me. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive
RE: $$Excel-Macros$$ cells shifting to Up!
Hello Anirut, Please start your own thread. Putting your question in an existing thread violates the rules and is confusing for others. Also see if you can phrase your question more clearly when you do so - I am unable to understand it. You might attach an example file. But in any case, please repost in a new thread. Do not reply. thanks, Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ANIRUT KOSAYAMAS Sent: Wednesday, March 21, 2012 3:06 AM To: excel-macros@googlegroups.com Cc: anirut...@gmail.com Subject: Re: $$Excel-Macros$$ cells shifting to Up! dear all Because of writing a VBA 2003 to 2007 by running the excel file. Details of the code is it to find information stored in the folder where the file excel 2003. I want to be by Chain version 2007 can not write code that would help me... password log modul 1 anirut.k fujikura production control -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Split text in cell
Option Explicit Sub getmiddleSAS() Dim c As Range Dim fs As Long Dim ls As Long For Each c In Range(a2:a10) c = Application.Trim(c) fs = InStr(c, ) ls = InStrRev(c, ) c.Offset(, 1) = Mid(c, fs, ls - fs) Next c Columns(b).AutoFit End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: NRao Mynampati Sent: Wednesday, March 21, 2012 4:00 AM To: excel-macros@googlegroups.com Cc: Dilip Pandey Subject: $$Excel-Macros$$ Split text in cell Hi Team, How to remove a words left text and right text of reference Please refer attachment. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******
You are doing a good job with a good forum. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ayush Jain Sent: Wednesday, March 21, 2012 5:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ ** FIVE YEARS COMPLETION**THANK YOU** Dear members, I am proud to announce that the forum has completed 5 years today. This is really great milestone of the forum. My sincere thanks to each one of you who keep this forum alive by asking questions and helping others by providing solutions. Over the last five years, I have seen decent growth in the number of posts and quality of solutions provided by the experts here. I have learned many things from this forum and experts. In my view, Learning never stops and the discussion forum is the best place to learn and share the skills. I hardly get time to resolve the excel queries after office hours but I try my best to moderate the forum closely. I visit the forum 2-3 times daily to approve the messages and to check everything is ok. Please let me know the improvements and changes you want to see in the forum. I would be happy to hear your feedback. Some key achievements of this forum in numbers: 1) In last 1.5 years, we have seen three people receiving the Microsoft MVP award from this forum. This is itself a big achievement for forum and I hope to see more deserving people get this award in future. 2) This is spam free forum and we hardly get spam messages. In last 5 years, 1000 members are banned for sending spam messages 3) We are 8400+ members with diversity in expertise, experience and location. 4) Over 7600+ topics discussed in five years Once again many thanks and congratulations to all of you. Keep posting and together we will achieve more milestones. Regards, Ayush Jain Microsoft MVP Forum Owner jainayus...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Help to find position of a particular number in a given data set
Hi Atul, Rank function seems to work perfectly fine here Copied the name of Institutions to A column and percentages to column B in C2 the formula was =RANK(B2,$B$2:$B$11,0) now drag the formula till C11 you get the desired result. Warm regards, Anand Kumar On Wednesday, 21 March 2012 02:54:21 UTC+5:30, Atul wrote: Hi, I need help to find position of a particular number in a given data set. Please refer to the table below. *Fin. Inst.* *Rates in %* A 10 B 11 C 12 D 11 E 6 F 9 G 8 H 8 I 9 J 7 In the above example, Rates are given for each financial institution. In descending order,the rate 12% is at the 1st position,11% is 2nd highest and so on. While using function LARGE or SMALL, we need to assign kth position to get the required result. I need to find (kth) position of given rate from the list, ignoring the duplicate items. Going back to the above example, 11% will be the second highest rate, 10% being the third highest rate and so on. Please let me know the function or combination of functions. Thank you for your help and time. Regards, *Atul Patel* H: 905 785 8324 C: 647 898 4074 atul_pate...@yahoo.com Good to know you ! *Atul Patel* H: 905 785 8324 C: 647 898 4074 atul_pate...@yahoo.com Good to know you ! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot table
Dear krishnaraddi, Attached sheet is blank, pls resend On Wed, Mar 21, 2012 at 6:27 PM, Krishnaraddi excelkris...@in.com wrote: Hi Excel gurus, I have attached excel sheet consisting of pivot table, For second column in the attached sheet I need count. How to achieve this without using Macros. Thanks in advance. Krish Dear *excel-macros!* Get Yourself a cool, short *@in.com* Email ID now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ email extraction from gmail
Dear Raj, Please try through below link. http://www.gmailextractor.com/ -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 21, 2012 at 11:56 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi group, can you please advice me how to extract email id's from gmail or outlook using VBA Thanks Regards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ email extraction from gmail
Outlook Email Address Extractor 3.3 Extract Email Addresses from Outlook mail folders with ease *Outlook Email Address Extractor* is a handy tool to *extract email addresses* and names from your Outlook emails (mail folders). It retrieves all valid email addresses and automatically removes duplicates. *Outlook Email Extractor * is compatible with Microsoft Outlook 2003, 2007, and *2010* (*both 32-bit and 64-bit editions*) [image: Outlook Email Extractor] *Download Free Trial Version* http://www.lmhsoft.com/oeesetup.exe On Wed, Mar 21, 2012 at 11:56 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi group, can you please advice me how to extract email id's from gmail or outlook using VBA Thanks Regards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ VBA COCE Required
Hello Goups Please give me a vba code , when we open the excel sheet then give me message Hello Welcome this sheet please provide me the VBA CODE. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Split text in cell
Dear All, Its good to see this resolution but can anyone explain this in simple way Regards Modi On Thu, Mar 22, 2012 at 4:51 AM, dguillett1 dguille...@gmail.com wrote: Option Explicit Sub getmiddleSAS() Dim c As Range Dim fs As Long Dim ls As Long For Each c In Range(a2:a10) c = Application.Trim(c) fs = InStr(c, ) ls = InStrRev(c, ) c.Offset(, 1) = Mid(c, fs, ls - fs) Next c Columns(b).AutoFit End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* NRao Mynampati ml.narasimha...@gmail.com *Sent:* Wednesday, March 21, 2012 4:00 AM *To:* excel-macros@googlegroups.com *Cc:* Dilip Pandey dilipan...@gmail.com *Subject:* $$Excel-Macros$$ Split text in cell Hi Team, How to remove a words left text and right text of reference Please refer attachment. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Compress of images
Dear Group how to compress images -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ words split from a cell - with formulas only Not for VBA code
Please find the attachment of my criteria. Please refer column A and i want result in Column 'B what I need like that. Thanks in advance Simha 970-309-1552 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Split a text.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ VBA COCE Required
Dear Jai, Please try it and see attached sheet. Private Sub Workbook_SheetActivate(ByVal Sh As Object) MsgBox Hello Welcome this sheet, vbInformation End Sub -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Thu, Mar 22, 2012 at 9:52 AM, Jai jaihumtu...@gmail.com wrote: Hello Goups Please give me a vba code , when we open the excel sheet then give me message Hello Welcome this sheet please provide me the VBA CODE. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Welcome to this sheet.xls Description: MS-Excel spreadsheet