Re: $$Excel-Macros$$ re: conversion of numbers
thanks. On 29 November 2011 11:05, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Hi Aamir, 1. Click the *Microsoft Office Button* [image: Button image], click *Excel Options*, and then click *Add-Ins*. 2. View the add-ins and application extensions that are categorized as follows: - *Active Application Add-ins* Lists the extensions that are registered and currently running in your Office program. - *Inactive Application Add-ins* Lists the add-ins that are present on your computer but are not currently loaded. For example, smart tags or XML Schemas are active only when the document that references them is open. Another example is the COM add-ins that are listed in the *COM Add-ins* dialog box. If the check box for a COM add-in is selected, the add-in is active. If the check box for a COM add-in is cleared, the add-in is inactive. To learn how to open the *COM Add-in* dialog box, see the section called Turn off or manage the installed add-inshttp://office.microsoft.com/en-us/help/enable-or-disable-add-ins-in-office-programs-HA010034127.aspx#BM2 . - *Document Related Add-ins* Lists template files that are referenced by currently open documents. - *Disabled Application Add-ins* Lists add-ins that were automatically disabled because they are causing Office programs to crash. how to use SureshAddin.xla syntax:- =rswords(cell no.) Example: suppose we have a num value in cell 'B2' we will write =rswords(b2) Regards, Ankit On Tue, Nov 29, 2011 at 12:56 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: how to recall this add-inn in working sheet. Regards, Aamir Shahzad On Mon, Nov 28, 2011 at 11:41 AM, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Hi Harsh, Use attached add-inn. Regards, Ankit On Mon, Nov 28, 2011 at 1:22 AM, Vinod Narayanan nvino...@gmail.comwrote: Hi Harsh, Select the cells which requires the formatting to be done and in Format Cells -- Custom, Please type *#,* to convert numbers in thousands and so on Option 1 = If base data is 10 - type *#,* in Format Cells -- Custom.. The result will be 100 Option 2 = If base data is 10 - type *#,,* in Format Cells -- Custom.. The result will be 1000 Option 3 = If base data is 10 - type *#,#,* in Format Cells -- Custom.. The result will be 1,000,000 Option 4 = If base data is 10 - type *#,#,,* in Format Cells -- Custom.. The result will be 1,000 Option 5 = If base data is 10 - type *#,#,,,* in Format Cells -- Custom.. The result will be 1 Please have an eye on the number of commas(,) added after hash(#) Thanks for the query Vinod On Sun, Nov 27, 2011 at 10:00 AM, harsh shah harshsha...@gmail.com wrote: dear all, i have a data sheet with numbers in it. i want to convert them into thousands or in lacs. is there a way to format the selected data cells so as to convert the same in thousands or in lacs ? harsh. -- 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
$$Excel-Macros$$ re: conversion of numbers
dear all, i have a data sheet with numbers in it. i want to convert them into thousands or in lacs. is there a way to format the selected data cells so as to convert the same in thousands or in lacs ? harsh. -- 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$$ remove a certain text from every sentence
you can use find replace. On 10 November 2011 10:39, smitha.kumari smitha.kum...@speridian.comwrote: Hi, ** ** I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya Technology Company:Jose ** ** I need only the name, “Technology Company:” has to be removed from every cells. Please reply. ** ** Regards Smitha ** ** -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) 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 (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) 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$$ Lesson 1: The Visual Basic Editor in Excel (VBE)
awaiting more lessons On 26 July 2011 09:24, XLS S xlst...@gmail.com wrote: ** *Lesson 1: The Visual Basic Editor in Excel (VBE) * *For users of Excel 1997 to 2006:* The first thing that you need to do is to make sure that the security level of Excel is set at either Low or Medium so that you can use the macros (VBA procedures) that you develop. From the menu bar of Excel select Tools then Macro then Security and select Medium. *For users of Excel 2007 to 2010:* From the Developer ribbon click on the Macro Security button. Check the second level Disable all Macros with Notification and you are set. *Setting up the Visual Basic Editor in Excel (VBE)* The Visual Basic Editor is a program within Excel that allows you to communicate with Excel. We will open it and start by setting it up so that working within it becomes easy and efficient. Print this page, open Excel and open a new workbook (Book1). On your keyboard press the ALT key (left of the space bar) and hold, strike the F11key (the F11 key is at the top of your keyboard).You now see the Visual Basic Editor. Again press ALT/F11 and you are back into Excel. Use the ALT/F11 key to go from Excel to the VBA and back. When you first open the VBE you will see is a window somewhat like the image below. If there are any open windows within the VBE like in the image below click on the Xs to close them and see a gray rectangle filling up the bottom part of the screen like in the image above. *The Three Windows in the Visual Basic Editor* To be efficient when working with the VBE there should always be 3 windows showing like in the image below; the Project Window (1), the Code Window ( 2), and the Properties Window (3), arranged as in the image below. You can resize the windows by left-clicking where the red stars are, holding and moving sideways or up and down. We will study each of the three windows in lessons 2, 3 and 4 but first we will set them up in the VBE. In the exercise below we will setup the 3 windows of the VBE. *Exercise 1* (Create your first macro and use it) Remember that you will perform this task only once as each time you will open the VBE it will remain setup. *Step 1:* Close all the windows that are open in the VBE to end up with this: *Step 2:* Go to the menu bar View and click Project Explorer. The result will be somewhat like the image below: If the project window already appears as a column on the left side of the screen there is nothing else that you have to do for now. If the project window appears in the middle of the gray area like above, right-click in the white space in the middle of the project window and check Dockable. Then click on the top blue bar of the Project window, hold and drag it left until the cursor (white arrow) touches the middle of the left side of the screen. When you let go of the mouse button the end result should be like shown in the image below. Congratulations you have setup the first major window of the VBE. *Step 3: *Move your cursor on the line separating the project window and the gray rectangle. When it turns to two small parallel lines and arrows click, hold and move the lines sideways. Resize the two windows as you want them. *Step 4:* Go back to the menu bar View and click Properties Window. The Properties window will appear somewhat like in the image below. If the Properties window is already located below the Project window there is nothing left to do. If it shows like in the image above, right-click in the white space in the middle of the Properties window and check Dockable. Then click on the top blue bar of the Properties window and drag it left and down until the cursor (white arrow) touches the center of the bottom of the Project window. When you let go of the mouse button the end result should be as the image below. Congratulations you have setup the second major window of the VBE. *Step 5: *Move your cursor on the line separating the project window and the properties window. When it turns to two small parallel lines and arrows click, hold and move the lines vertically. Resize the two windows as you want them. *Step 6: *To add the code window to the setup, you just have to double click on the name of a component in the Project window (Sheet1, Sheet2, Sheet3 or ThisWorkbook) and its code window appears within the gray rectangle. You can maximize any Code window by clicking on its Maximize button . The final result looks like the image below. The words Option Explicit might not be present in your Code window. We will address this issue later in the lesson on variables (Lesson 19). You might also have a VBAProject named FUNCRES.XLA or FUNCRES.XLAM in the project window. Forget about this project for now. *Step 6: *Now go to Excel and close it. Re-open Excel, go to the VBE (ALT/F11) and you will see that the VBE setup persists. Congratulations, you are now ready to work in the Visual
Re: $$Excel-Macros$$ Help regarding bank statment
HOPE THIS MIGHT BE USEFUL. On 8 July 2011 10:09, L.K. Modi ca.mod...@gmail.com wrote: Dear Members, Thanks for your valuable support. I have an querry in which i have to check interest calculation for banks. Me attaching a sheet in which column A have date that is in different format. and in column B the balance as on the respective dates. As the bank charges interest on the closing balance for particular dates. So there are many balances as on the same date. What i need first that the date should be in format of dd-mmm-yy and secondly like there are many balances of 1st june so i need only the closing balance of 1st june and so on. it means last line that is in 1st june this i have to do for all dates. can anyone help me as this is more time taking without proper direction. Thanks in advance Regards LKModi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel test_sheet(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel Password Breaker Code...
let me know how to use the same to break existing password protected sheet. On 24 March 2011 15:35, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Experts., Please find use below VBA code to break password in EXCEL Procedure : Press alt+F11 Insert-Module then Paste below code Press-F5 to run *Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer* * On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) Chr(j) Chr(k) _ Chr(l) Chr(m) Chr(i1) Chr(i2) Chr(i3) _ Chr(i4) Chr(i5) Chr(i6) Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox One usable password is Chr(i) Chr(j) _ Chr(k) Chr(l) Chr(m) Chr(i1) Chr(i2) _ Chr(i3) Chr(i4) Chr(i5) Chr(i6) Chr(n) ActiveWorkbook.Sheets(1).Select Range(a1).FormulaR1C1 = Chr(i) Chr(j) _ Chr(k) Chr(l) Chr(m) Chr(i1) Chr(i2) _ Chr(i3) Chr(i4) Chr(i5) Chr(i6) Chr(n) Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next* *End Sub *-- Thanks regards, Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Freeze the cell once the Data has been entered?
hey this was good one 2009/12/13 Dilip Pandey dilipan...@gmail.com Dear Ramesh, Required automation is attached herewith. Thanks Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/10/09, Chanti-Hyderabad ramesh1...@gmail.com wrote: Hi Excel Gurus, Looking for the following actions in excel. 1. As soon as I select an option from the drop down, the cell should be frozen, rather locked. 2. Further Cell should not allow any user to edit the data Please let me know if you have any questions. Regards, --Ramesh -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE
name: harsh shah subject : formula reference tip : press ctrl + [ (will show from where the formula has been derived) ctrl + ] (will show where this cell has been used in formula) On 10/06/2009, Rakesh Sharma rak_sha...@yahoo.co.in wrote: HI All, Name : Rakesh Shar,ma Subject : Show formulas in printable format Tip : Press Ctrl + ~ ( To View formulas in printable format or to take a printout for forumlas enter in cells) On Jun 5, 8:41 pm, Ayush jainayus...@gmail.com wrote: Hello Everyone, Please submit your tip in this post for Week # 24. I am looking for your overwhelming response in this competition.You just need to submit your name along with the tip and subject. The tip can be shortcut, trick, hidden secret, etc. Last Submission Date-13th June 2009. Winner Declaration Date -14th June 2009. Example : Name : Ayush Jain Subject : the Great 'F4' Tip : The 'F4' is easily the most useful shortcut key in Excel. Basically it repeats your last command. So say you changed the color of a font in a cell. Now click in a new cell and hit 'F4' and it will change the font in the new cell to the same color.Wonderful, right? Well what's great about this is that it works for nearly everything else in Excel too.Highlight a row, right- click and choose 'Delete'. Now highlight another row and hit 'F4'. It deletes that row.Whatever you did last, Excel will attempt to repeat the same command until you do something else. This works great for things that require you to go to the menus or right-click and make choices or click buttons that bring up more dialogs. It can be huge time saver once you get used to using it. As the help says, it doesn't work in every situation but most times 'F4' works great. SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP WIN PRIZES. Invite your friends too for participation in the contest. The more participation means more learning. Thanks again, Ayush Jain --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ help required -
hello i want currency to be shown in terms of lacs crores instead of millions. can anyone provide help on comma presentation ? any add in for that ? -harsh. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: amt in words in excel add-in
*Installation Copy the attached file to the folder where excel stores the add-ins. (To know where excel stores the add-ins, open any workbook, click on Tools - Add-ins - Browse) Then open an excel workbook. Click on Tools - Add-ins - Browse - Give the path to this Addin - Ok* ** NO PASSWORD REQUIRED... 2009/3/30 S.Ashok S.Ashok ashoki...@gmail.com Hi Guys, What is the password for amt in words in excel add-in. Pl reply asap. S.Ashok On Tue, Mar 24, 2009 at 12:18 AM, harsh shah harshsha...@gmail.comwrote: dear all, i hope these files might be of some use. AmtInWords.xla is attached to this mail. It is an MS Excel Add-in to convert amount available in figures to words. Installation Copy the attached file to the folder where excel stores the add-ins. (To know where excel stores the add-ins, open any workbook, click on Tools - Add-ins - Browse) Then open an excel workbook. Click on Tools - Add-ins - Browse - Give the path to this Addin - Ok Usage You can use the functions AmtInWords and AmtInWordsUS in any worksheet. The syntax is: =AmtInWords(decimal number/cell reference, [currency code/cell ref], [no. of decimals]) =AmtInWordsUS(decimal number/cell reference, [currency code/cell ref], [no. of decimals]) Explanation The function AmtInWords gives the output in lakhs/crores. The function AmtInWordsUS gives the output in million/billion. The first parameter for these functions is compulsory … you can give a number or the reference of a cell containing a number (absolute or calculated) The second parameter is the currency code. This is optional (the default is INR) and is to be given if you use a different currency than INR The third parameter is the number of decimals in the fraction part. This is optional (the default is 2) and is to be given if it is different. At present, the accepted values are 0, 2 and 3 Examples =AmtInWords(1000) =AmtInWords(123456.77) =AmtInWords(123456.747, OMR,3) =AmtInWords(C4) =AmtInWords(C4,A3) ' Where C4 contains a number and A3 a currency code =AmtInWordsUS(B3) ' Shall give the amount in millions (US format) =AmtInWordsUS(B3,USD) ' Shall give the amount in millions (US format) and in US currency (Dollars) =AmtInWords(C4,GBP) ' Shall give the amount in lakhs and in UK currency (Pounds) =AmtInWordsUS(B3,OMR,3) ' Shall give the amount in millions and in Oman currency (Omani Rial) which has upto 3 decimals in the fraction part Notes The system shall NOT give you any warning/error if you use: =AmtInWords(C4,USD) ' Amount in lakhs and in US currency (Dollars) OR =AmtInWordsUS(C4,GBP) ' Amount in millions and in UK currency (Pounds) At present 6 currency codes are supported: INR (the default ... not required to be given separately) USD (dollars) GBP (pounds) EUR (euros) OMR (Omani rials) BDT ( Bangladesh Taka) -- With warm regards, S.Ashok --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---