RE: $$Excel-Macros$$ Dynamic criterion range for Advanced filtering
Could you please attach an excel worksheet for the problem you are facing. Regards, C.G.Kumar -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Philip Sent: 01/February/2010 5:26 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Dynamic criterion range for Advanced filtering To automatically track the criterion range area for advanced filtering when adding a value on the next row in the criterion range (so that I can filter Value A OR Value B), I want to make the criterion range dynamic. However, when repeating the Advanced filter command after inputting Value B on the second row, the Advanced filter command makes the criterion range static again, e.g. : The dynamic range correctly tracks the criterion range to be two rows for Value A (Heading row and first value row). Now I add Value B to another field on the second value row. When repeating the Advanced filter, the criterion range has been converted to a static X1:Y2 range (for two fields). I want the criterion range to remain dynamic to track the range as now X1:Y3. How do I overcome this problem, without resorting to VBA (which is an easy work around but does not give me the flexibility I want.) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Any way to use customer icons with conditional formatting?
One easy way to do it is to use the camera tool named ranges. The basic idea is contained in the link below. You'd just swap out the traffic lights for your own icons. http://www.exceluser.com/solutions/traffic.htm On Mon, Feb 1, 2010 at 12:50 PM, TD tim.deros...@gmail.com wrote: I am doing analysis of 8 possible conditions and would like to insert a custom icon based on the number in the cell. The intent is to provide a graphical representation for each cell's value. I've tried the icon sets available with coditional formatting. I like the concept, but would really like to use my own icons. Recomendations? TD -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED
hello friends, i had send my files to the moderator of group , you will find them shortly in our file section no need to post request here , just mail me on my id ankurpande...@gmail.com On 01/02/2010, asha abraham abrash...@gmail.com wrote: Hi Ankur, could u pls send me the VBA e-books to my id... thanks in advance. rgds ash@ On Sat, Jan 30, 2010 at 4:10 PM, ankur ankurpande...@gmail.com wrote: hi chetan i had send some ebooks at your email id plz check it On 30/01/2010, chethan chethan...@gmail.com wrote: Hi Everybody, i am very new to the world of VBA macros. i would like to learn macros can anybody help me out in getting the proper way to get available materials to learn the VBA from the scratch. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Dataform applied to a database not starting in Row 1
Hi Philip, Please share an example with attachment. So that we can find a workaround on it. I am a Data Analyst I did lots of projects on Database programming, might be after looking your example I can provide a good solution of your problem. Thanks, Deepak On Mon, Feb 1, 2010 at 5:23 PM, Philip phi...@eya-bantu.co.za wrote: I have two databases in a worksheet, the second's headers are on Row 40. On highlighting the second's headers and data, the Dataform correctly picks up the related fields. However, when running VBA code, the dataform defaults to the fields of the first database in Row 1. A workaround this problem? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Please help
On Tue, Feb 2, 2010 at 7:02 PM, Sri Jai jaisri1...@gmail.com wrote: Dear All, Can somebody please help me on the below two scenarios 1) On the attached I would like to have columns E, F, G and H which is highlighted Yellow below when I run a Macro. These new columns must be automatically inserted E F G H *Txn Type* *Security ID* *Security Code-Cash* *Sec Description* * * * * * * * * * * * * * * * * * * * * * * 2) I have run a Macro to reflect Column K debit and Credit amounts to reflect in column Q and R Can the data which is presently reflecting in column Q and R reflect in K for debit and L for credit? Presently K= Debit and Credit Amounts M= Debit and Credit Present Output= Q debit amounts and R credit amounts Desired output file= K debitand debit amounts and L credit and credit amounts and delete column M Thanks a ton for the help Thanks Sri On Tue, Feb 2, 2010 at 7:02 PM, Sri Jai jaisri1...@gmail.com wrote: Dear All, Can somebody please help me on the below two scenarios 1) On the attached I would like to have columns E, F, G and H which is highlighted Yellow below when I run a Macro. These new columns must be automatically inserted E F G H *Txn Type* *Security ID* *Security Code-Cash* *Sec Description* * * * * * * * * * * * * * * * * * * * * * * 2) I have run a Macro to reflect Column K debit and Credit amounts to reflect in column Q and R Can the data which is presently reflecting in column Q and R reflect in K for debit and L for credit? Presently K= Debit and Credit Amounts M= Debit and Credit Present Output= Q debit amounts and R credit amounts Desired output file= K debit and L credit and delete column M Thanks a ton for the help Thanks Sri -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Password crecker for Excel workbbok
Try this macro 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 On Wed, Jan 13, 2010 at 7:33 AM, Mahesh Kumar sharmaji.mah...@gmail.comwrote: Send your excel file regards Mahesh On Jan 10, 3:32 pm, maulik desai mauliksde...@gmail.com wrote: Hi, Can any one provide me the password breaker or macros or any tool which can break the password to open the Excel workbook i am takiing abt to open password protected Excel workbook (not to unprotect the password protected sheet) i hope from this best group some one will help me -- Thanks Regards, Maulik Desai 9967363926 -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@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.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Send to Sheet in the body of mail
Hi All, i am trying to send my sheet in the body of the mail by ms outlook.. but i can't send it.. i was wrote a few codes and when i try it by codes it is write an message in body your browser don't support that it is telling my browser don't support that way.. my friends using office 2003 , they can send it so easly but i am using office 2007 and it don't allow to send it... how can i solve that problem? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ how to declare define global range in vba
Hello Group, How can we declare and define Global range in vba , so that it can be used across procedures modules ? Public rngNetLineAmt as range Set rngNetLineAmt = Sheets(M-RAW).Range(AQ:AQ) If i use above code outside the procedure..it does not work and throws error. Kindly advise. Thank you so much. -Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ how to declare define global range in vba
What module are you putting the declaration in? For instance, if you right-click on a sheet tab and select View Code it opens up the VBA Sheet Module. You'll notice a module called ThisWorkBook If you create standard Modules, there will be a folder called Modules and a list of modules (default names are Module1, Module2) A standard module will be created if you record a macro. You cannot declare Public variables in Sheet modules. They MUST be in 'standard' modules. Although they MIGHT be allowed in 'class' modules, but not in form modules. Next. You can DECLARE it using: Public but I think you have to SET it within a macro. I THINK basically it's because sheets and ranges are dynamic and you're trying to treat a variable as a constant But I could be wrong. Paul From: Ayush jainayus...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, February 2, 2010 11:24:36 AM Subject: $$Excel-Macros$$ how to declare define global range in vba Hello Group, How can we declare and define Global range in vba , so that it can be used across procedures modules ? Public rngNetLineAmt as range Set rngNetLineAmt = Sheets(M-RAW).Range(AQ:AQ) If i use above code outside the procedure..it does not work and throws error. Kindly advise. Thank you so much. -Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to stop a loop when a condition is met, but then resume?
I have a spreadsheet that contains a list. I need to evaluate all of the cells in a particular column. I want the code to step through each cell in the column and, if the color index of the cell is RED (color index = 3), I want the code to stop so that I can look at the spreadsheet and make a decision (nothing to do with the code). Once the decision has been made, I want to be able to continue running the code and continue evaluating the cells in the column, until the values in the column end. Is this something that is possible? Thanks! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Forms in Visual basic scroll bar problem
Hi Thanks for the reply. The form i am editing / creating is part of Excel.. to get to it TOOLS - MACRO - VISUAL BASIC EDITOR I have some screen shots of the form running and also of the form in VB Editor but cant find how to send these to this group to help explain better ? If this is possible could you let me know how to do this ? Kind regards Andy a...@amwarkup.co.uk On Jan 28, 2:00 pm, Paul Schreiner schreiner_p...@att.net wrote: First of all, you've not asked a question. You have a scrollable box that displays up to 50 entries, you have an Excel file with 200 items to diaplay in the scoll box. in a userform, a scrollbox is a box that can have a large number of entries, and the scroll portion allows the user to see the entries that are not displayed. Seems like all is right with the world... so what's the problem? also, I'm confused about your terminology. Microsoft has three distinct products called: Visual Basic (VB) Visual Basic Script (VBS) Visual Basic for Applications (VBA) VBA runs within excel and can have userforms. Visual Basic runs in Windows and can have userforms. Visual Basic Script runs in Windows and DOES NOT have userforms, and generally isn't the best application to use to create menus (no checkboxes, or option buttons. just yes/no/cancel/abort/retry) You said that you're using visual basic script to form a menu at the top of your screen. menu's are generally part of the toolbar of an Application, not at the top of the screen, So, are you really using VBA to create a scrollable menu item in the Excel toolbar? and once again, if the item is scrollable, WHY would you want it to show 200 items all at once? I think we need some clarification (or at least *I* do!) sorry, Paul From: andyfloyd a...@amwarkup.co.uk To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, January 28, 2010 3:45:14 AM Subject: $$Excel-Macros$$ Forms in Visual basic scroll bar problem Hi all, new to this group so please bear with me. The question I have is this... I have a spreadsheet with several pages each with a list of components on them. I then have a visual basic script to form a menu at the top of my screen which allows it to call up a form for users to fill in details and select items from a form page to create the spreadsheet. The problem I have is for instance:- Page 1 on my spreadsheet has 200 items on it Page 1 on my form to fill in has a scroll box which only allows it to view around 50 lines Any ideas? A screen shot can be taken of the form or I can send the spreadsheet to anyone who can help Kind regards in anticipation Andy -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads athttp://www.excelitems.com 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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 HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ multiple dropdown lists height problem
Hi, I have the following problem, when I create some dropdown boxes via VBA then all 99 ones have the some height and length in the excel sheet. But when I save the file and open it again, then some of the dropdown boxes are smaller or bigger then before. Has anybody a good idea? Thank you Code: Sub Add_Dropdown() Left1 = 1 Length1 = 60 Height1 = 15 For i = 2 To 100 Adresse = Cells2Range(i, 1) ' Function Converts Cell to Range Data Range(Adresse).Select Top1 = Selection.Top Set ddBox = ActiveSheet.DropDowns.Add(Left1, Top1, Length1, Height1) With ddBox .ListFillRange = Data!$A$2:$A$10 .LinkedCell = Adresse .DropDownLines = 8 .Display3DShading = False End With Next end sub Function Cells2Range(Zeile, Spalte) Spalte = Columns(Spalte).Address(False, False) Spalte = Left(Spalte, InStr(Spalte, :) - 1) Cells2Range = Spalte Zeile End Function -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Please help
give this a shot. Sub macrotrythis() 'insert and label the 4 new columns --- note: your sample has (4) columns here which I presume normally are not? Columns(E:E).Insert Shift:=xlToRight: Range(E1).Value = Sec Description Columns(E:E).Insert Shift:=xlToRight: Range(E1).Value = Security Code-Cash Columns(E:E).Insert Shift:=xlToRight: Range(E1).Value = Security Id Columns(E:E).Insert Shift:=xlToRight: Range(E1).Value = Txn Type Columns(H:H).Interior.ColorIndex = 6 'turn column H yellow 'copy column K values to column Q, and column L to column R based on the transaction code in column(m) For Row = 2 To Range(a1).End(xlDown).Row Range(Q Row).Select 'just to watch the action, remove for speed 'question:your example shows the copied values moved DOWN 3 rows from source 'if this is incorrect then dont need TargetRow; ie: just use Range (QRow).value TargetRow = Row + 3 Select Case UCase(Trim(Range(M Row).Value)) Case DEBIT: Range(Q TargetRow).Value = Range(K Row).Value Case CREDIT: Range(R TargetRow).Value = Range(K Row).Value Case Else: Range(S TargetRow).Value = Range(K Row).Value End Select Next Row Columns(Q:S).AutoFit 'Columns(M:M).Delete Range(R4).Select 'end with cursor at R4 when done End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Help on this task please
I have the code listed below that searches a folder and if it finds any PDF files its displays them with a hyperlink in the spreadsheet. My problem is that under the MAIN folder I have tons of files now and its very hard to find the PDF I am looking for. I redid my file structure under main and now I have folders for years 2010, 2012,2013,2014,2015 and so on. Under each years directory are the directories for the 12 months of the year under each of these months I have two folders A-cast B-cast. What I would like is that the code could search the folders starting form MAIN by prompting the user for the year, than the month then the folder name And then display contents of the folder as results on the spreadsheet If a user did not have lets say the folder names A- cast B-cast the program could display contents of both A-cast B- cast. Here is the code I got from the forum. Sub all_2010() ' Macro to searh display PDf files Dim i As Long With Application.FileSearch .NewSearch .SearchSubFolders = True .Filename = *.pdf .LookIn = c:\Scans\TW\MAIN .Execute For i = 1 To .FoundFiles.Count ActiveSheet.Hyperlinks.Add Anchor:=Range(A i), _ Address:=.FoundFiles(i), TextToDisplay:= _ Right(.FoundFiles(i), Len(.FoundFiles(i)) - _ InStrRev(.FoundFiles(i), \)) Next End With End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ how to declare define global range in vba
Hi Ayush, What do you mean by outside the procedure'? Dave. Date: Tue, 2 Feb 2010 08:24:36 -0800 Subject: $$Excel-Macros$$ how to declare define global range in vba From: jainayus...@gmail.com To: excel-macros@googlegroups.com Hello Group, How can we declare and define Global range in vba , so that it can be used across procedures modules ? Public rngNetLineAmt as range Set rngNetLineAmt = Sheets(M-RAW).Range(AQ:AQ) If i use above code outside the procedure..it does not work and throws error. Kindly advise. Thank you so much. -Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ Time for a new car? Sell your old one fast! http://clk.atdmt.com/NMN/go/157637060/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help on this task please
Air code, not tested Sub all_2010() ' Macro to searh display PDf files Dim i As Long dim d1 as string dim d2 as string dim d3 as string dim d4 as string d1=inputbox(Select year, 1988-2010) d2=inputbox(Select months, Jan-Dec) d3=inputbox(Select A or B folder, default to both) if d3= then d3=A-cast d4=B-cast end if full_dir=c:\Scans\TW\MAIN \ d1 \ d2 \ d3 call searchsub(full_dir) if d4 then full_dir=c:\Scans\TW\MAIN \ d1 \ d2 \ d4 call searchsub(full_dir) end if end sub sub searchsub(fulldirectory as string) With Application.FileSearch .NewSearch .SearchSubFolders = True .Filename = *.pdf .LookIn = fulldirectory .Execute For i = 1 To .FoundFiles.Count ActiveSheet.Hyperlinks.Add Anchor:=Range(A i), _ Address:=.FoundFiles(i), TextToDisplay:= _ Right(.FoundFiles(i), Len(.FoundFiles(i)) - _ InStrRev(.FoundFiles(i), \)) Next End With End Sub On Wed, Feb 3, 2010 at 3:39 AM, Dave davidstev...@gmail.com wrote: I have the code listed below that searches a folder and if it finds any PDF files its displays them with a hyperlink in the spreadsheet. My problem is that under the MAIN folder I have tons of files now and its very hard to find the PDF I am looking for. I redid my file structure under main and now I have folders for years 2010, 2012,2013,2014,2015 and so on. Under each years directory are the directories for the 12 months of the year under each of these months I have two folders A-cast B-cast. What I would like is that the code could search the folders starting form MAIN by prompting the user for the year, than the month then the folder name And then display contents of the folder as results on the spreadsheet If a user did not have lets say the folder names A- cast B-cast the program could display contents of both A-cast B- cast. Here is the code I got from the forum. Sub all_2010() ' Macro to searh display PDf files Dim i As Long With Application.FileSearch .NewSearch .SearchSubFolders = True .Filename = *.pdf .LookIn = c:\Scans\TW\MAIN .Execute For i = 1 To .FoundFiles.Count ActiveSheet.Hyperlinks.Add Anchor:=Range(A i), _ Address:=.FoundFiles(i), TextToDisplay:= _ Right(.FoundFiles(i), Len(.FoundFiles(i)) - _ InStrRev(.FoundFiles(i), \)) Next End With End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ how to declare define global range in vba
Hi Paul, I have been using the Standard module. The idea is to create an add-in. The problem is that I have to use a particular range in different modules and different procedures but i don't want to define them in each procedure. Any idea ? Thank you. On Tue, Feb 2, 2010 at 10:59 PM, Paul Schreiner schreiner_p...@att.netwrote: What module are you putting the declaration in? For instance, if you right-click on a sheet tab and select View Code it opens up the VBA Sheet Module. You'll notice a module called ThisWorkBook If you create standard Modules, there will be a folder called Modules and a list of modules (default names are Module1, Module2) A standard module will be created if you record a macro. You cannot declare Public variables in Sheet modules. They MUST be in 'standard' modules. Although they MIGHT be allowed in 'class' modules, but not in form modules. Next. You can DECLARE it using: Public but I think you have to SET it within a macro. I THINK basically it's because sheets and ranges are dynamic and you're trying to treat a variable as a constant But I could be wrong. Paul -- *From:* Ayush jainayus...@gmail.com *To:* MS EXCEL AND VBA MACROS excel-macros@googlegroups.com *Sent:* Tue, February 2, 2010 11:24:36 AM *Subject:* $$Excel-Macros$$ how to declare define global range in vba Hello Group, How can we declare and define Global range in vba , so that it can be used across procedures modules ? Public rngNetLineAmt as range Set rngNetLineAmt = Sheets(M-RAW).Range(AQ:AQ) If i use above code outside the procedure..it does not work and throws error. Kindly advise. Thank you so much. -Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Help on excel formula
I forgot to say that YEARFRAC is from the Analysis ToolPak Dave. From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help on excel formula Date: Wed, 3 Feb 2010 13:01:33 +0800 Hi I've used the YEARFRAC funtion and multiplied it by 12. Have a look at the attached. Some of your manual entries were incorrect. I have highlighted them in yellow. Regards - Dave. Date: Wed, 3 Feb 2010 00:18:50 +0530 Subject: $$Excel-Macros$$ Help on excel formula From: karankan...@gmail.com To: excel-macros@googlegroups.com CC: karankan...@gmail.com Hi, I have an excel sheet where i have to calculate the difference between 2 dates giving the answer in months. e.g. Difference between these 2 dates 31-3-09 1-2-07, and the answer to be in months. I have calculated the difference between the dates (by using a formula), but in few cases there is a difference of one month which i am getting, which is wrong. Pls find the attached sheet and give me a formula which can be used for the entire sheet and that i dont get any difference between the calculated and the actual correct months. The Difference is marked in red. Thanking you in anticipation. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sell your old one fast! Time for a new car? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ View photos of singles in your area! Browse profiles for FREE http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Password crecker for Excel workbbok
Hi Guru, How to use this code pls explain full Thanks In Advance Nandkumar On Tue, Feb 2, 2010 at 6:27 PM, Auto Tours Inv Limited auto.to...@gmail.com wrote: Try this macro 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 On Wed, Jan 13, 2010 at 7:33 AM, Mahesh Kumar sharmaji.mah...@gmail.comwrote: Send your excel file regards Mahesh On Jan 10, 3:32 pm, maulik desai mauliksde...@gmail.com wrote: Hi, Can any one provide me the password breaker or macros or any tool which can break the password to open the Excel workbook i am takiing abt to open password protected Excel workbook (not to unprotect the password protected sheet) i hope from this best group some one will help me -- Thanks Regards, Maulik Desai 9967363926 -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@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.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe