Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach
you can download it from this link *http://www.easy-share.com/1909713544/Excel 2007 Bible.pdf Regards Hemant Koranne * On Fri, May 14, 2010 at 10:06 AM, Vikas Chouhan vikask...@gmail.com wrote: me also send pleasvikask...@gmail.com On Thu, May 13, 2010 at 11:22 AM, Nani Ram 06n...@gmail.com wrote: Hi Excel Masters, Could any one have MS-Excel Bible by john walkenbach e-book. if so could please send it to me at 06n...@gmail.com. Thanks in advance, Nani Ram -- -- 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 6,800 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 -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, We can't Spell S_ccess without U Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- 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 6,800 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 Hemant Koranne Check out my web site for learning excel http://exceltnt.blogspot.com/ -- -- 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 6,800 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$$ Excel Wonders(Excel formulas)
hi, thanx On Thu, May 13, 2010 at 12:03 PM, Rajesh Nair nairra...@gmail.com wrote: Hi All, Please find attached Excel formula book . This may help. Regards, Rajesh. Nair -- -- 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 6,800 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 -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, We can't Spell S_ccess without U Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- 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 6,800 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$$ Ms-Excel Bible by john walkenbach
i had also found 2003 version shall i upload it to the forum. On Fri, May 14, 2010 at 10:12 AM, Mr excel excelkeec...@gmail.com wrote: hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it here. On Thu, May 13, 2010 at 11:52 PM, Nani Ram 06n...@gmail.com wrote: Hi Excel Masters, Could any one have MS-Excel Bible by john walkenbach e-book. if so could please send it to me at 06n...@gmail.com. Thanks in advance, Nani Ram -- -- 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 6,800 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 6,800 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: Extract Right Word in Line
hi sorry about that command we can use right command for that regards vikas On Wed, May 12, 2010 at 9:19 AM, anand shivappa anand.shiva...@gmail.com wrote: Can you send me the code for RTRIM it. Because I cannot find in Excel function list. Thanks and Regards, Anand S On Tue, May 11, 2010 at 6:10 PM, vikas gupta vikas.63...@gmail.com wrote: HI ANAND YOU CAN USE RTRIM COMMAND REGARDS VIKAS GUPTA 9311334683 On Thu, May 6, 2010 at 6:15 PM, anand shivappa anand.shiva...@gmail.com wrote: Please help out. I got struct here. On Thu, May 6, 2010 at 5:45 PM, anand shivappa anand.shiva...@gmail.com wrote: Hi Everyone, I need to extract a rightmost word in a line through excel functions. Like USA Street is having no 10. I need to extract the last word like 10. Please help me out. Thanks and Regards, Anand S -- When everything fails Patience will win -- When everything fails Patience will win -- -- 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 6,800 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 6,800 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 -- When everything fails Patience will win -- -- 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 6,800 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 6,800 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$$ Excel Wonders(Excel formulas)
Hi Rajesh The document is really impressive. Can you please guide where to find its latest version after Office 2010 has appeared in the market and may be author has made changes since then as its v1.0 Beta copyright 1998-2001. I am grateful to you. AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 14 May 2010 08:57, Aindril De aind...@gmail.com wrote: Hi Rajesh, A nice one for quick reference... Thanks buddy Regards, Andy On Fri, May 14, 2010 at 12:33 AM, Rajesh Nair nairra...@gmail.com wrote: Hi All, Please find attached Excel formula book . This may help. Regards, Rajesh. Nair -- -- 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 6,800 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 6,800 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 6,800 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$$ Excel Wonders(Excel formulas)
thanks a ton. . . Sent from my Nokia phone -Original Message- From: Vikas Chouhan Sent: 14/05/2010 10:13:25 am Subject: Re: $$Excel-Macros$$ Excel Wonders(Excel formulas) hi, thanx On Thu, May 13, 2010 at 12:03 PM, Rajesh Nair nairra...@gmail.com wrote: Hi All, Please find attached Excel formula book . This may help. Regards, Rajesh. Nair -- -- 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 6,800 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 -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, We can't Spell S_ccess without U Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- 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 6,800 subscribe Email truncated to 2,000 characters :::0:93a54c3be213e907c81c6c47c07444d6:7d0 -- -- 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 6,800 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$$ Ms-Excel Bible2007 by john walkenbach
I friends, i have excel-2007 bible by john walkenbach, if anybody wants, just inform me, i will send to their e mail id. regards sudhir On Fri, May 14, 2010 at 10:14 AM, Mr excel excelkeec...@gmail.com wrote: i had also found 2003 version shall i upload it to the forum. On Fri, May 14, 2010 at 10:12 AM, Mr excel excelkeec...@gmail.com wrote: hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it here. On Thu, May 13, 2010 at 11:52 PM, Nani Ram 06n...@gmail.com wrote: Hi Excel Masters, Could any one have MS-Excel Bible by john walkenbach e-book. if so could please send it to me at 06n...@gmail.com. Thanks in advance, Nani Ram -- -- 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 6,800 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 6,800 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- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- -- 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 6,800 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$$ Ms-Excel Bible by john walkenbach
I friends, i have excel-2007 bible by john walkenbach, if anybody wants, just inform me, i will send to their e mail id. regards sudhir On Fri, May 14, 2010 at 10:14 AM, Mr excel excelkeec...@gmail.com wrote: i had also found 2003 version shall i upload it to the forum. On Fri, May 14, 2010 at 10:12 AM, Mr excel excelkeec...@gmail.com wrote: hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it here. On Thu, May 13, 2010 at 11:52 PM, Nani Ram 06n...@gmail.com wrote: Hi Excel Masters, Could any one have MS-Excel Bible by john walkenbach e-book. if so could please send it to me at 06n...@gmail.com. Thanks in advance, Nani Ram -- -- 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 6,800 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 6,800 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- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- -- 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 6,800 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$$ Need Help for Macro or Formula
Dear All for attach sheet i need formula or macro, I will appreciate any help on this. 1.if for code in column A ,status in column C is paid then D column status should be process 2.if status in column C is not paid or awaiting then D column status should be not to process 3. there is blank line between two codes in column A below mention formula not working. =IF(A3=,,IF(C3=Paid,Process,Not to process)) -- -- 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 6,800 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 Sample sheet.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Macro to send emails using excel list
Dear friends Below you can find the code I wrote to make Excel send emails thought a list of names My problem is the attachment talk. I need a code that gets all files from a certain directory and attach into the email using the .attachment.Add Does anyone know how to do that ? Thanks in advance Dim olApp As Object Dim olMail As Object Dim olSubject Dim olTratamneto Dim olName Dim olMsg Dim FirstLine Dim LastLine Dim olAttachment As FileDialog Dim olAttachmentDirectory As Object LastLine = Cells(65536, 1).End(xlUp).Row olTratamento = InputBox(Insira aqui uma mensagem que vem antes do Nome do seu cliente como Dear,Hello, Etc _ , Tratamento da Mensagem, Hello ) olSubject = InputBox(Insira o assunto do email, Subjetc Box, BROTHERS IN GRANITE OFFER) Set olApp = CreateObject(Outlook.application) Set olMail = olApp.CreateItem(0) Set olAttachment = Application.FileDialog(msoFileDialogFilePicker) With olAttachment .AllowMultiSelect = True End With FirstLine = 2 For i = FirstLine To LastLine olName = Cells(FirstLine, 1).Value With olMail .OriginatorDeliveryReportRequested = True ' delivery confirmation .ReadReceiptRequested = True ' read confirmation .Subject = olSubject .To = Cells(FirstLine, 2).Value .CC = Cells(FirstLine, 3).Value .BCC = Cells(FirstLine, 4).Value .Body = olTratamneto Chr(32) Cells(FirstLine, 1).Value Chr(13) Chr(13) Sheets(MAIL_OFFER).Cells(1, 1).Value .Attachment.Add = Several file End With Next i End Sub -- -- 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 6,800 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$$ Need Help for Macro or Formula
Hi Mahesh, You wrote: *Dear All * *for attach sheet i need formula or macro, I will appreciate any help on this. 1.if for code in column A ,status in column C is paid then D column status should be process 2.if status in column C is not paid or awaiting then D column status should be not to process 3. there is blank line between two codes in column A below mention formula not working. =IF(A3=,,IF(C3=Paid,Process,Not to process)) * In the attached sheet, first two points have been closed. 3) point is not clear at all. Syntax of the If formula is as follows: =IF(Condition,Statement if condition is true,statement if condition is false) If you can throw some more light on what do you want to achieve, then may be we can help you Thanks Harry -- -- 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 6,800 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 Sample+sheet(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach
Yes, would you please send to me also? Many thanks. Sent from my BlackBerry Smartphone provided by Alltel -Original Message- From: sudhir kumar sudhir.p...@gmail.com Date: Fri, 14 May 2010 21:23:43 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach I friends, i have excel-2007 bible by john walkenbach, if anybody wants, just inform me, i will send to their e mail id. regards sudhir On Fri, May 14, 2010 at 10:14 AM, Mr excel excelkeec...@gmail.com wrote: i had also found 2003 version shall i upload it to the forum. On Fri, May 14, 2010 at 10:12 AM, Mr excel excelkeec...@gmail.com wrote: hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it here. On Thu, May 13, 2010 at 11:52 PM, Nani Ram 06n...@gmail.com wrote: Hi Excel Masters, Could any one have MS-Excel Bible by john walkenbach e-book. if so could please send it to me at 06n...@gmail.com. Thanks in advance, Nani Ram -- -- 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 6,800 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 6,800 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- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- -- 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 6,800 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 6,800 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 Help for Macro or Formula
check the sheet. On Fri, May 14, 2010 at 9:25 PM, Mahesh parab mahes...@gmail.com wrote: Dear All for attach sheet i need formula or macro, I will appreciate any help on this. 1.if for code in column A ,status in column C is paid then D column status should be process 2.if status in column C is not paid or awaiting then D column status should be not to process 3. there is blank line between two codes in column A below mention formula not working. =IF(A3=,,IF(C3=Paid,Process,Not to process)) -- -- 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 6,800 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 Saurabh Singh -- -- 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 6,800 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 Sample sheet-updtd.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Insert Blank Rows after detecting a specific text string
UCase function Returns a Variant (String) containing the specified string, converted to uppercase. Syntax: UCase(string) Example Range A10 contain text data : tOtaL Cost x = UCase(Left(Range(A10)),5) return x = TOTAL x = Left(Range(A10),5) returns x = tOtaL comparing UCase(Left(Range(A10)),5) = TOTAL returns TRUE comparing Left(Range(A10)),5) = TOTAL returns FALSE CMIIW best rgds siti On May 14, 12:50 am, John Whetstone johnw...@gmail.com wrote: Thanks for the code... I am trying it out it all makes sense to me, except UCase -- what is it? It's not a function... and when I run this code , nothing happens -- can you explain a little more? Sorry, but I am a novice... On Wed, May 12, 2010 at 6:55 PM, siti Vi villager.g...@gmail.com wrote: Sub Bla_Bla_Bla() Dim MyRng As Range, n As Long Set MyRng = ActiveSheet.UsedRange For n = MyRng.Rows.Count To 1 Step -1 If UCase(Left(Trim(MyRng(n, 1)), 5)) = TOTAL _ Then MyRng(n + 1, 1).EntireRow.Insert Next End Sub NOTE: to insert a row you have to say the range object first: RangeObject.EntireRow.Insert -- -- 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 6,800 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$$ Ms-Excel Bible by john walkenbach
Mr excel, Can you send the link for 2003 version Thanks Harry -- -- 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 6,800 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$$ Do not request or provide copyrighted eBook in group.
Dear Group, Please do not send any request of copyrighted material in group. Any ebook/material which is copyrighted should not be shared in forum as it is a loss for the owner of that item. You are always welcome to share thoughts, idea , queries, tips and tricks in group. They are not copyrighted at all :) I hope you understand the same. Any such message again could lead to termination from the group membership. Keep Posting. Best regards, Ayush Jain Group Owner -- -- 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 6,800 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