Hello Asish, Is there any way where we can make part of string to bold and color it?
Thanks, Chandra Shekar B On Thu, Aug 18, 2011 at 9:13 AM, Chandra Shekar < chandrashekarb....@gmail.com> wrote: > Thanks a lot Ashish. Its working fine. :-) > > > On Thu, Aug 18, 2011 at 2:01 AM, ashish koul <koul.ash...@gmail.com>wrote: > >> try this one >> >> >> On Wed, Aug 17, 2011 at 1:25 PM, Chandra Shekar < >> chandrashekarb....@gmail.com> wrote: >> >>> Hello Ashish, >>> >>> Could u pls help on this error. Thanks! >>> >>> On Tue, Aug 16, 2011 at 11:25 AM, Chandra Shekar < >>> chandrashekarb....@gmail.com> wrote: >>> >>>> Hi Ashish, >>>> >>>> Thanks for the reply and patience. I have attached the excel file. I am >>>> facing below errors when I run the macro. >>>> >>>> 1. I am getting error as shown in mailerro1.bmp >>>> 2. I am not getting formated output in mail output as shown in >>>> mailerror2.bmp. >>>> >>>> Thanks, >>>> On Tue, Aug 16, 2011 at 10:01 AM, ashish koul >>>> <koul.ash...@gmail.com>wrote: >>>> >>>>> hi chandar >>>>> >>>>> i tried it its working fine also ur code is password protected .can u >>>>> unlock it and send it again >>>>> >>>>> >>>>> On Tue, Aug 16, 2011 at 12:43 PM, Chandra Shekar < >>>>> chandrashekarb....@gmail.com> wrote: >>>>> >>>>>> Hi Ashish, >>>>>> >>>>>> Please find attached file and kindly do the needful. Thanks in >>>>>> advance. >>>>>> >>>>>> On Tue, Aug 16, 2011 at 5:40 AM, ashish koul <koul.ash...@gmail.com >>>>>> > wrote: >>>>>> >>>>>>> can you attach your file >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Mon, Aug 15, 2011 at 5:35 PM, Chandra Shekar < >>>>>>> chandrashekarb....@gmail.com> wrote: >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> I am getting attached error while running the macro. Please let me >>>>>>>> know whats the error in the below code. >>>>>>>> >>>>>>>> *MailDoc.Save True, True, False* >>>>>>>> >>>>>>>> Regards, >>>>>>>> >>>>>>>> Chandra Shekar B >>>>>>>> On Mon, Aug 15, 2011 at 11:43 AM, Chandra Shekar < >>>>>>>> chandrashekarb....@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hi Asish, >>>>>>>>> Thank u for the help again I am getting error in the below code. >>>>>>>>> Please let me know whats the problem in the below code. >>>>>>>>> >>>>>>>>> Thanks in advance. >>>>>>>>> ** >>>>>>>>> *MailDoc.Save True, True, False >>>>>>>>> * >>>>>>>>> On Mon, Aug 15, 2011 at 9:53 AM, ashish koul < >>>>>>>>> koul.ash...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> dont use .copy in set statement >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar < >>>>>>>>>> chandrashekarb....@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>>> Hello Ashish, >>>>>>>>>>> >>>>>>>>>>> I got solution for this issue but I am getting one more error in >>>>>>>>>>> code as type mismatch >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> *Set rnbody1 = Sheets("Details").UsedRange.Copy >>>>>>>>>>> rnbody1.Copy >>>>>>>>>>> >>>>>>>>>>> * >>>>>>>>>>> On Fri, Aug 12, 2011 at 9:12 AM, Chandra Shekar < >>>>>>>>>>> chandrashekarb....@gmail.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi Ashsh, >>>>>>>>>>>> >>>>>>>>>>>> I used ur code but getting error in below lines. I think I need >>>>>>>>>>>> to enable some reference. Please let me know about this. >>>>>>>>>>>> >>>>>>>>>>>> *Set Data = New DataObject >>>>>>>>>>>> Data.GetFromClipboard >>>>>>>>>>>> * >>>>>>>>>>>> Thanks, >>>>>>>>>>>> >>>>>>>>>>>> Chandra Shekar B >>>>>>>>>>>> On Fri, Aug 12, 2011 at 8:21 AM, Chandra Shekar < >>>>>>>>>>>> chandrashekarb....@gmail.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Thanks Ashish I will check it out. :-) >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Fri, Aug 12, 2011 at 4:31 AM, ashish koul < >>>>>>>>>>>>> koul.ash...@gmail.com> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> try these >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Wed, Aug 10, 2011 at 6:10 PM, Chandra Shekar < >>>>>>>>>>>>>> chandrashekarb....@gmail.com> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> In below code some times I could able to send attachments but >>>>>>>>>>>>>>> some times its not taking attachment at all. Please let me know >>>>>>>>>>>>>>> whats is the >>>>>>>>>>>>>>> problem in the below code. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Sub sendmail() >>>>>>>>>>>>>>> ' >>>>>>>>>>>>>>> Dim UserName As String >>>>>>>>>>>>>>> Dim MailDbName As String >>>>>>>>>>>>>>> Dim Recipient As Variant >>>>>>>>>>>>>>> Dim ccRecipient As String >>>>>>>>>>>>>>> Dim Attachment1 As String >>>>>>>>>>>>>>> Dim Maildb As Object >>>>>>>>>>>>>>> Dim MailDoc As Object >>>>>>>>>>>>>>> Dim AttachME As Object >>>>>>>>>>>>>>> Dim AttachME2 As Object >>>>>>>>>>>>>>> Dim AttachME3 As Object >>>>>>>>>>>>>>> Dim AttachME4 As Object >>>>>>>>>>>>>>> Dim AttachME5 As Object >>>>>>>>>>>>>>> Dim Session As Object >>>>>>>>>>>>>>> Dim EmbedObj1 As Object >>>>>>>>>>>>>>> Dim EmbedObj2 As Object >>>>>>>>>>>>>>> Dim EmbedObj3 As Object >>>>>>>>>>>>>>> Dim EmbedObj4 As Object >>>>>>>>>>>>>>> Dim EmbedObj5 As Object >>>>>>>>>>>>>>> Dim stSignature As String >>>>>>>>>>>>>>> With Application >>>>>>>>>>>>>>> .ScreenUpdating = False >>>>>>>>>>>>>>> .DisplayAlerts = False >>>>>>>>>>>>>>> ' Open and locate current LOTUS NOTES User >>>>>>>>>>>>>>> Set Session = CreateObject("Notes.NotesSession") >>>>>>>>>>>>>>> UserName = Session.UserName >>>>>>>>>>>>>>> MailDbName = Left$(UserName, 1) & Right$(UserName, >>>>>>>>>>>>>>> (Len(UserName) - InStr(1, UserName, " "))) & ".nsf" >>>>>>>>>>>>>>> Set Maildb = Session.GetDatabase("", MailDbName) >>>>>>>>>>>>>>> If Maildb.IsOpen = True Then >>>>>>>>>>>>>>> Else >>>>>>>>>>>>>>> Maildb.OPENMAIL >>>>>>>>>>>>>>> End If >>>>>>>>>>>>>>> ' Create New Mail and Address Title Handlers >>>>>>>>>>>>>>> Set MailDoc = Maildb.CREATEDOCUMENT >>>>>>>>>>>>>>> MailDoc.Form = "Memo" >>>>>>>>>>>>>>> stSignature = >>>>>>>>>>>>>>> Maildb.GetProfileDocument("CalendarProfile").GetItemValue("Signature")(0) >>>>>>>>>>>>>>> ' Select range of e-mail addresses >>>>>>>>>>>>>>> Recipient = notes_id >>>>>>>>>>>>>>> MailDoc.SendTo = Recipient >>>>>>>>>>>>>>> MailDoc.Subject = "Test Mail " >>>>>>>>>>>>>>> MailDoc.Body = "Hi," & vbCrLf & vbCrLf & "Please find >>>>>>>>>>>>>>> attached schedule for the day " & vbCrLf & vbCrLf & "Regards" & >>>>>>>>>>>>>>> vbCrLf & >>>>>>>>>>>>>>> vbCrLf & "Chandru" >>>>>>>>>>>>>>> ' Select Workbook to Attach to E-Mail >>>>>>>>>>>>>>> MailDoc.SaveMessageOnSend = True >>>>>>>>>>>>>>> Attachment1 = "C:\temp.bmp" ' Required File Name" >>>>>>>>>>>>>>> If Attachment1 <> "" Then >>>>>>>>>>>>>>> On Error Resume Next >>>>>>>>>>>>>>> Set AttachME = MailDoc.CREATERICHTEXTITEM("Attachment1") >>>>>>>>>>>>>>> Set EmbedObj1 = AttachME.EmbedObject(1454, "", Attachment1, >>>>>>>>>>>>>>> "Attachment1") >>>>>>>>>>>>>>> MailDoc.CREATERICHTEXTITEM ("Attachment1") >>>>>>>>>>>>>>> On Error Resume Next >>>>>>>>>>>>>>> End If >>>>>>>>>>>>>>> MailDoc.PostedDate = Now() >>>>>>>>>>>>>>> On Error GoTo errorhandler1 >>>>>>>>>>>>>>> MailDoc.SEND 0, Recipient >>>>>>>>>>>>>>> Set Maildb = Nothing >>>>>>>>>>>>>>> Set MailDoc = Nothing >>>>>>>>>>>>>>> Set AttachME = Nothing >>>>>>>>>>>>>>> Set AttachME2 = Nothing >>>>>>>>>>>>>>> Set AttachME3 = Nothing >>>>>>>>>>>>>>> Set AttachME4 = Nothing >>>>>>>>>>>>>>> Set AttachME5 = Nothing >>>>>>>>>>>>>>> Set Session = Nothing >>>>>>>>>>>>>>> Set EmbedObj1 = Nothing >>>>>>>>>>>>>>> Set EmbedObj2 = Nothing >>>>>>>>>>>>>>> Set EmbedObj3 = Nothing >>>>>>>>>>>>>>> Set EmbedObj4 = Nothing >>>>>>>>>>>>>>> Set EmbedObj5 = Nothing >>>>>>>>>>>>>>> .ScreenUpdating = True >>>>>>>>>>>>>>> .DisplayAlerts = True >>>>>>>>>>>>>>> Exit Sub >>>>>>>>>>>>>>> End With >>>>>>>>>>>>>>> errorhandler1: >>>>>>>>>>>>>>> MsgBox Err.Description >>>>>>>>>>>>>>> Set Maildb = Nothing >>>>>>>>>>>>>>> Set MailDoc = Nothing >>>>>>>>>>>>>>> Set AttachME = Nothing >>>>>>>>>>>>>>> Set AttachME2 = Nothing >>>>>>>>>>>>>>> Set AttachME3 = Nothing >>>>>>>>>>>>>>> Set AttachME4 = Nothing >>>>>>>>>>>>>>> Set AttachME5 = Nothing >>>>>>>>>>>>>>> Set Session = Nothing >>>>>>>>>>>>>>> Set EmbedObj1 = Nothing >>>>>>>>>>>>>>> Set EmbedObj2 = Nothing >>>>>>>>>>>>>>> Set EmbedObj3 = Nothing >>>>>>>>>>>>>>> Set EmbedObj4 = Nothing >>>>>>>>>>>>>>> Set EmbedObj5 = Nothing >>>>>>>>>>>>>>> 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 >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>>>>>>>>> Like our page on facebook , Just follow below link >>>>>>>>>>>>>>> http://www.facebook.com/discussexcel >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> *Regards* >>>>>>>>>>>>>> * * >>>>>>>>>>>>>> *Ashish Koul* >>>>>>>>>>>>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>>>>>>>>>>>>> http://akoul.posterous.com/ >>>>>>>>>>>>>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>>>>>>>>>>>>> My Linkedin >>>>>>>>>>>>>> Profile<http://in.linkedin.com/pub/ashish-koul/10/400/830> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> P Before printing, think about the environment. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> >>>>>>>>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>>>>>>>> Some important links for excel users: >>>>>>>>>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>>>>>>>>> http://twitter.com/exceldailytip >>>>>>>>>>>>>> 2. Join our LinkedIN group @ >>>>>>>>>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>>>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>>>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>>>>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>>>>>>>>> >>>>>>>>>>>>>> To post to this group, send email to >>>>>>>>>>>>>> excel-macros@googlegroups.com >>>>>>>>>>>>>> >>>>>>>>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>>>>>>>> Like our page on facebook , Just follow below link >>>>>>>>>>>>>> http://www.facebook.com/discussexcel >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> >>>>>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>>>>> Some important links for excel users: >>>>>>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>>>>>> http://twitter.com/exceldailytip >>>>>>>>>>> 2. Join our LinkedIN group @ >>>>>>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>>>>>> >>>>>>>>>>> To post to this group, send email to >>>>>>>>>>> excel-macros@googlegroups.com >>>>>>>>>>> >>>>>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>>>>> Like our page on facebook , Just follow below link >>>>>>>>>>> http://www.facebook.com/discussexcel >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> *Regards* >>>>>>>>>> * * >>>>>>>>>> *Ashish Koul* >>>>>>>>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>>>>>>>>> http://akoul.posterous.com/ >>>>>>>>>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>>>>>>>>> My Linkedin >>>>>>>>>> Profile<http://in.linkedin.com/pub/ashish-koul/10/400/830> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> P Before printing, think about the environment. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> >>>>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>>>> Some important links for excel users: >>>>>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>>>>> http://twitter.com/exceldailytip >>>>>>>>>> 2. Join our LinkedIN group @ >>>>>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>>>>> >>>>>>>>>> To post to this group, send email to >>>>>>>>>> excel-macros@googlegroups.com >>>>>>>>>> >>>>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>>>> Like our page on facebook , Just follow below link >>>>>>>>>> http://www.facebook.com/discussexcel >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> ---------------------------------------------------------------------------------- >>>>>>>> Some important links for excel users: >>>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>>> http://twitter.com/exceldailytip >>>>>>>> 2. Join our LinkedIN group @ >>>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>>> >>>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>>> >>>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>>> Like our page on facebook , Just follow below link >>>>>>>> http://www.facebook.com/discussexcel >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> *Regards* >>>>>>> * * >>>>>>> *Ashish Koul* >>>>>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>>>>>> http://akoul.posterous.com/ >>>>>>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>>>>>> My Linkedin Profile<http://in.linkedin.com/pub/ashish-koul/10/400/830> >>>>>>> >>>>>>> >>>>>>> P Before printing, think about the environment. >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> ---------------------------------------------------------------------------------- >>>>>>> Some important links for excel users: >>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>> http://twitter.com/exceldailytip >>>>>>> 2. Join our LinkedIN group @ >>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>> >>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>> >>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>> Like our page on facebook , Just follow below link >>>>>>> http://www.facebook.com/discussexcel >>>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> ---------------------------------------------------------------------------------- >>>>>> Some important links for excel users: >>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>> http://twitter.com/exceldailytip >>>>>> 2. Join our LinkedIN group @ >>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>> >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>> Like our page on facebook , Just follow below link >>>>>> http://www.facebook.com/discussexcel >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> *Regards* >>>>> * * >>>>> *Ashish Koul* >>>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>>>> http://akoul.posterous.com/ >>>>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>>>> My Linkedin Profile<http://in.linkedin.com/pub/ashish-koul/10/400/830> >>>>> >>>>> >>>>> P Before printing, think about the environment. >>>>> >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> Like our page on facebook , Just follow below link >>>>> http://www.facebook.com/discussexcel >>>>> >>>> >>>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >> http://akoul.posterous.com/ >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >> >> >> P Before printing, think about the environment. >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel