Re: $$Excel-Macros$$ Fwd: hi
=CONCATENATE(A1, ,TEXT(DATE(YEAR(TODAY()), MONTH(TODAY())+1, DAY(TODAY())),mmm-yy)) A1 is the cell value where your text is stored. OR =CONCATENATE(Dr.X, may verify the particulars furnished above and inform whether any changes before the pay bills are prepared for the month of ,TEXT(DATE(YEAR(TODAY()), MONTH(TODAY())+1, DAY(TODAY())),mmm-yy)) Hope this helps. AJ On Wed, Jul 28, 2010 at 9:21 PM, sudarshan rampe sidhu...@gmail.com wrote: hi friends i need small help from you guys. i have attached the excel sheet, in which at the end of the sentence i want to add the Month and year of the next coming month. please help me out -- Sidhu -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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: Creating formula using VBA
Hi Dave, Much appreciation every works perfect. Hug Love On Thu, Jul 29, 2010 at 7:08 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, In H4 enter: =IF(G4=0,,D4/G4) And similarly for other cells that contain a division operator Basically we are saying, if the denominator = 0 then nothing, otherwise, do the math. Regards - Dave. -- Date: Wed, 28 Jul 2010 21:08:00 +0300 Subject: $$Excel-Macros$$ Help: Creating formula using VBA From: janetdicks...@gmail.com To: excel-macros@googlegroups.com Hi Team, I have a challenge, how can I create a formula using VBA?! Attached file show details, but i don't want to see *#DIV/0! *error in case columns used in division does not have any data!! column E - F = column G (sometimes column E - F does not have any data, so i don't want to see 0 in column G column (G/D) = column H (sometimes column G or D does not have any data, so i don't want to see *#DIV/0! *error Jen D -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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: Creating formula using VBA
Hi, You can use below formula in H4 cell =IF(ISERROR(D10/G10),,(D10/G10)) Thanks, Noorain Ansari -- Date: Wed, 28 Jul 2010 21:08:00 +0300 Subject: $$Excel-Macros$$ Help: Creating formula using VBA From: janetdicks...@gmail.com To: excel-macros@googlegroups.com Hi Team, I have a challenge, how can I create a formula using VBA?! Attached file show details, but i don't want to see *#DIV/0! *error in case columns used in division does not have any data!! column E - F = column G (sometimes column E - F does not have any data, so i don't want to see 0 in column G column (G/D) = column H (sometimes column G or D does not have any data, so i don't want to see *#DIV/0! *error Jen D -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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 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 HELP US GROW !! We reach over 7000 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$$ Pivot Table
Hi, In the below code I have vba code which get student wise report using pivot table. Here I need chart with report also. Thanks in advance. Sub pivot2_creation() Dim pvt_che As PivotCache Dim pvt_tbl As PivotTable Set Rng = Sheet1.UsedRange Set pvt_che = ThisWorkbook.PivotCaches.Create(xlDatabase, Rng) Set pvt_tbl = pvt_che.CreatePivotTable(Worksheets(3).Range(A1)) With pvt_tbl .AddFields Array(Stud Nm, Class, Kannada, English, Maths, Science, Social) End With With pvt_tbl .CalculatedFields.Add Marks Total, =sum(Kannada+English+Maths +Science+Social) .CalculatedFields.Add Percentages, =Marks Total/600*100 End With With pvt_tbl.PivotFields(Marks Total) .Orientation = xlDataField .NumberFormat = #,##0.00 End With With pvt_tbl.PivotFields(Percentages) .Orientation = xlDataField .NumberFormat = #,##0.00 End With On Error Resume Next For i = 2 To pvt_tbl.PivotFields.Count a = pvt_tbl.PivotFields(i).Name With pvt_tbl.PivotFields(a) .LayoutForm = xlTabular .Subtotals = Array(False, False, False, False, False, False, False, False, False, False, False, False) End With Next On Error GoTo 0 With pvt_tbl .PivotFields(Stud Nm).LayoutBlankLine = True .NullString = 0 .ShowDrillIndicators = False .ColumnGrand = False .RowGrand = False .InGridDropZones = False .PivotFields(Sum of Marks Total).Caption = Marks Total .PivotFields(Sum of Percentages).Caption = Percentage .TableStyle2 = PivotStyleLight17 .DisplayFieldCaptions = True End With With pvt_tbl pitm_cnt = pvt_tbl.PivotFields(Stud Nm).PivotItems.Count For j = 1 To pitm_cnt pitem = pvt_tbl.PivotFields(Stud Nm).PivotItems(j) For i = 1 To pitm_cnt pvtitem = pvt_tbl.PivotFields(Stud Nm).PivotItems(i) If pvtitem = pitem Then pvt_tbl.PivotFields(Stud Nm).PivotItems(pvtitem).Visible = True Else pvt_tbl.PivotFields(Stud Nm).PivotItems(pvtitem).Visible = False End If Next .TableRange1.Offset(2, 0).Copy add_sht (pitem) For Each pvtfld In pvt_tbl.PivotFields(Stud Nm).PivotItems pvtfld.Visible = True Next i = i + 1 Next End With Set pvt_che = Nothing Set pvt_tbl = Nothing End Sub Sub add_sht(ByRef pitem As String) ThisWorkbook.Worksheets.Add After:=Worksheets(Worksheets.Count) ThisWorkbook.Worksheets(Worksheets.Count).Name = pitem With ThisWorkbook.Worksheets(pitem) .Range(A3).PasteSpecial xlPasteValuesAndNumberFormats .Range(A2:I2) = Array(Stud Nm, Class, Kannada, English, Maths, Science, Social, Marks, Percentange) .Range(A1) = Progess Report of pitem .Range(A1:I1).Merge .Range(A1:I1).HorizontalAlignment = xlCenter .Range(A1:I1).Font.ColorIndex = 45 .Range(A1).Font.Size = 15 .Range(A1).Font.Bold = True .Range(A2:I2).Font.Bold = True .Range(A2:I2).Font.ColorIndex = 55 .Range(A1).Select .Columns.AutoFit End With With Worksheets(3) Application.CutCopyMode = False End With End Sub Regards, Chandra Shekar B -- -- 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 HELP US GROW !! We reach over 7000 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$$ Fwd: hi
thanks abishek the second one worked out.. -- -- 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 HELP US GROW !! We reach over 7000 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$$ Need Formula
Hi, Can u check this this can be helpor not On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear All, Please find attach the sheet wherein I need the Data from Tracking Sheet should go the each individual sheets the data. Please see attach file for more understanding. Waiting for your ideas and suggestions... -- Ahmed Bawazir -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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 Need_Help.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ VBA macro to open web page then enter phonenumber and submit
Guys, Can anyone help me on this? Thank You... On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hi, I need to open an internal webpage after a phone number is entered into a spreadsheet then submit these details on the webpage and the result is paste on the spreadsheet. Is there a way of doing this? Thanks in advance! Manoj Kumar -- M.K.V --- The state of your life is nothing more than a reflection of your state of mind. --- -- -- 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 HELP US GROW !! We reach over 7000 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 -- M.K.V --- The state of your life is nothing more than a reflection of your state of mind. --- -- -- 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 HELP US GROW !! We reach over 7000 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$$ Maximum With Criteria...NEWBIE
Hello All, I have a collumn called problem, in that collum i recieved a mapped value but it is doing it wrong. I need the formula to get the highest value in *Kgs* Column (criteria same *date*, same *code_number)*. Based on the *Kgs *Maximum value, it has to get the *code* on the left side column and then map it to the 3 Letter Code on the right table. But there is a small problem, is that all the files that are smaller than the maximum that have the same *date *and *code_numbe*r number should also have the same 3 Letter code as the maximum. PS: Formula is in portuguese ,i believe PROCV is Vlookup or Lookup and SOMARPRODUTO is SUMPRODUCT -- -- 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 HELP US GROW !! We reach over 7000 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 max.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ VBA macro to open web page then enter phonenumber and submit
plz provide us some samle data and the website where to upload the data. regards, simran On Thu, Jul 29, 2010 at 2:48 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Guys, Can anyone help me on this? Thank You... On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hi, I need to open an internal webpage after a phone number is entered into a spreadsheet then submit these details on the webpage and the result is paste on the spreadsheet. Is there a way of doing this? Thanks in advance! Manoj Kumar -- M.K.V --- The state of your life is nothing more than a reflection of your state of mind. --- -- -- 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 HELP US GROW !! We reach over 7000 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 -- M.K.V --- The state of your life is nothing more than a reflection of your state of mind. --- -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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$$ create macro to find first empty row
i need to create a macro which put the cursor in the first empty cell in the same row of the actual active cell. i tried to use a for cycle but it doesn't work, could you please help me? Dim sh As Worksheet Dim lColonna As Long Dim row As Range Set sh = Worksheets(sheet1) ActiveCell.Offset(-1, 1).Select Set row = ActiveCell.row.Select With sh For lColonna = 1 To .Columns.Count If .Cells(row, lColonna).Value = Then Sheets(sheet1).Select Cells(row, lColonna).Select Exit For End If Active.cell.Offset(1, 1).Select Next End With -- -- 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 HELP US GROW !! We reach over 7000 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: automation error
Thanks a lot stuart... Actually i have a excel file in which there are names written of all the operators and each operator will have a excel file. In the macro code it will select a file usin the application.open method then it will calculate the data accordin to the criteria specified. After that it will open each excel file and update the data respectively. This error occurs at times while updatin the data. but no error is specified the only thing is it shows a save as dialogue box with the junk name i have specified before but when i click on cancel or save, the excel crashes. kindly help saber On Tue, Jul 20, 2010 at 5:19 PM, Stuart Redmann dertop...@web.de wrote: On 19 Jul., mohd ateeq wrote: HI all, Can anyone help me out with the following error: Run-time error ‘-2147417848 (80010108)’: Automation error The object invoked has disconnected from its clients It occurs when I create around 30-40 new excel files based on some criteria and update as and when there is a updates by opening each excel file and update using the vba code. When this error occurs, there will be a one more file created with a junk name like 7EA78f10 ……and shows a save as dialogue box, when I click on cancel the above error message is displayed and when I save that file, it says “Excel has encountered a problem and need to close and it will start recovering the files again. Please help me out Thanks… This error message indicates that something very fundamental is going wrong. Usually you will only get it if there is a COM server (for example Excel) that houses some COM objects (your Excel workbooks) shuts unexpectedly down (IOW, Excel crashes). Since it is quite easy to make Excel crash, it will be quite hard to find out what exactly causes the crash. The 7EA78f10 file you have mentioned may be a clue which of the opened Excel files caused the crash (this file is certainly the result from an auto-recover of Excel). However, we need _much_ more information about what you are doing, best of all a minimal example that exposes the behaviour. Do you create the new Excel files in a separate Excel server? If so, have you enabled macro processing in these servers? Regards, Stuart -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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$$ create macro to find first empty row
Hi, Try this line of code: Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1).Select Regards - Dave. Date: Thu, 29 Jul 2010 05:27:59 -0700 Subject: $$Excel-Macros$$ create macro to find first empty row From: federico.mazz...@ikea.com To: excel-macros@googlegroups.com i need to create a macro which put the cursor in the first empty cell in the same row of the actual active cell. i tried to use a for cycle but it doesn't work, could you please help me? Dim sh As Worksheet Dim lColonna As Long Dim row As Range Set sh = Worksheets(sheet1) ActiveCell.Offset(-1, 1).Select Set row = ActiveCell.row.Select With sh For lColonna = 1 To .Columns.Count If .Cells(row, lColonna).Value = Then Sheets(sheet1).Select Cells(row, lColonna).Select Exit For End If Active.cell.Offset(1, 1).Select Next End With -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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$$ Index match with 3 criteria
Hi Nadine, Have a look at the formula. The $M$2:$M$5 shoukd be $R$2:$R$5 Regards - Dave. Date: Thu, 29 Jul 2010 07:28:24 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com This worked originally but for some reason isn't working now. I've included the file which is my file I'm working with and not the sample any more. The data in the Extract will vary in length. I have the exact same formula in your sample but it's not working now. Can anyone figure out what's wrong? I appreciate all the help. Nadine From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Sat, July 17, 2010 1:07:56 AM Subject: RE: $$Excel-Macros$$ Index match with 3 criteria Hi Nadine, Have a look at the attached to see if it does what you need. I've used array formulas, so I don't know how it will go if your actual file is very large. There's a couple of #NA's in the list because they have no match. Regards - Dave. Date: Fri, 16 Jul 2010 10:16:13 -0700 From: n8dine4ma...@yahoo.com Subject: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com Here is a sample sheet that explains what I need. 3 columns in sheet 1 need to match the same in sheet 2 and return an item from sheet2. Thanks. -- -- 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 HELP US GROW !! We reach over 7000 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 Australia's #1 job site If It Exists, You'll Find it on SEEK -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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$$ Index match with 3 criteria
I sent this email this morning and haven't heard back. I really really hope someone can help with this because I truly have no clue on how to make this work and really need it to. I know I could do a concatenation cell in each sheet and search that way but I'd really like to keep it cleaner. Thanks again. From: Nadine S n8dine4ma...@yahoo.com To: excel-macros@googlegroups.com Sent: Thu, July 29, 2010 7:28:24 AM Subject: Re: $$Excel-Macros$$ Index match with 3 criteria This worked originally but for some reason isn't working now. I've included the file which is my file I'm working with and not the sample any more. The data in the Extract will vary in length. I have the exact same formula in your sample but it's not working now. Can anyone figure out what's wrong? I appreciate all the help. Nadine From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Sat, July 17, 2010 1:07:56 AM Subject: RE: $$Excel-Macros$$ Index match with 3 criteria Hi Nadine, Have a look at the attached to see if it does what you need. I've used array formulas, so I don't know how it will go if your actual file is very large. There's a couple of #NA's in the list because they have no match. Regards - Dave. Date: Fri, 16 Jul 2010 10:16:13 -0700 From: n8dine4ma...@yahoo.com Subject: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com Here is a sample sheet that explains what I need. 3 columns in sheet 1 need to match the same in sheet 2 and return an item from sheet2. Thanks. -- -- 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 HELP US GROW !! We reach over 7000 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 Australia's #1 job site If It Exists, You'll Find it on SEEK -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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$$ Index match with 3 criteria
Thank you so much. I just couldn't see it. I hate when that happens. From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thu, July 29, 2010 4:38:54 PM Subject: RE: $$Excel-Macros$$ Index match with 3 criteria Hi Nadine, Have a look at the formula. The $M$2:$M$5 shoukd be $R$2:$R$5 Regards - Dave. Date: Thu, 29 Jul 2010 07:28:24 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com This worked originally but for some reason isn't working now. I've included the file which is my file I'm working with and not the sample any more. The data in the Extract will vary in length. I have the exact same formula in your sample but it's not working now. Can anyone figure out what's wrong? I appreciate all the help. Nadine From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Sat, July 17, 2010 1:07:56 AM Subject: RE: $$Excel-Macros$$ Index match with 3 criteria Hi Nadine, Have a look at the attached to see if it does what you need. I've used array formulas, so I don't know how it will go if your actual file is very large. There's a couple of #NA's in the list because they have no match. Regards - Dave. Date: Fri, 16 Jul 2010 10:16:13 -0700 From: n8dine4ma...@yahoo.com Subject: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com Here is a sample sheet that explains what I need. 3 columns in sheet 1 need to match the same in sheet 2 and return an item from sheet2. Thanks. -- -- 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 HELP US GROW !! We reach over 7000 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 Australia's #1 job site If It Exists, You'll Find it on SEEK -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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
RE: $$Excel-Macros$$ Index match with 3 criteria
No Problem. Dave. Date: Thu, 29 Jul 2010 16:41:18 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com Thank you so much. I just couldn't see it. I hate when that happens. From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thu, July 29, 2010 4:38:54 PM Subject: RE: $$Excel-Macros$$ Index match with 3 criteria Hi Nadine, Have a look at the formula. The $M$2:$M$5 shoukd be $R$2:$R$5 Regards - Dave. Date: Thu, 29 Jul 2010 07:28:24 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com This worked originally but for some reason isn't working now. I've included the file which is my file I'm working with and not the sample any more. The data in the Extract will vary in length. I have the exact same formula in your sample but it's not working now. Can anyone figure out what's wrong? I appreciate all the help. Nadine From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Sat, July 17, 2010 1:07:56 AM Subject: RE: $$Excel-Macros$$ Index match with 3 criteria Hi Nadine, Have a look at the attached to see if it does what you need. I've used array formulas, so I don't know how it will go if your actual file is very large. There's a couple of #NA's in the list because they have no match. Regards - Dave. Date: Fri, 16 Jul 2010 10:16:13 -0700 From: n8dine4ma...@yahoo.com Subject: $$Excel-Macros$$ Index match with 3 criteria To: excel-macros@googlegroups.com Here is a sample sheet that explains what I need. 3 columns in sheet 1 need to match the same in sheet 2 and return an item from sheet2. Thanks. -- -- 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 HELP US GROW !! We reach over 7000 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 Australia's #1 job site If It Exists, You'll Find it on SEEK -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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
Re: $$Excel-Macros$$ Fwd: hi
You're welcome. However, both works. 1st one is having reference of the text, and in second one, text is within the formula. That's the only difference. AJ On Thu, Jul 29, 2010 at 1:42 AM, sudarshan rampe sidhu...@gmail.com wrote: thanks abishek the second one worked out.. -- -- 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 HELP US GROW !! We reach over 7000 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$$ Fwd: Help Needed_Very Urgent
Hi, The Recd Date and Completion date is differs for each employee. So you mean to say that date range has to be generated for each employee. Could you suggest the format in which you want this to be done ? Regard Vasant Hi Vasant, This works great. Thanks for your help. Need a small change on this. The attached file will have dates already presented in sheet Dummy. Now what I want to have the dates automatically populated when macro running. The macro should check the minimum date in column E(Recv Date) and maximum date in column F(Compleation Date). Then it should populate the dates from min date to max date automatically. As and when I run the macro it should populate the dates based on minimum and maximum automatically. Note: if min date is 09/07/2010 and max date is 12/08/2010 then the macro should populate dates from cell B2-09/07/2010, B3-10/07/2010, B4-11/07/201012/08/2010. till the last date. Thanks for your time, Looking for your help to proceed further. Thanks again, Sharma On Tue, Jul 27, 2010 at 9:39 AM, Vasant vasant...@gmail.com wrote: Hope this is works... Regards Vasant On Tue, Jul 27, 2010 at 4:22 PM, amrahs k amrahs...@gmail.com wrote: Hi Dilip, I have attached the sample file with my query. Please look into this and help me to proceed further since i have left with only one working day. Looking for your help, Thanks in Advance, Sharma -- -- 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 HELP US GROW !! We reach over 7000 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 -- Regards Vasant -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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 -- Regards Vasant -- -- 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 HELP US GROW !! We reach over 7000 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