Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread Venkat CV
glegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Venkat CV > *Sent:* Wednesday, August 03, 2011 2:09 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Vlookup Including Cell Comments.. > > ** ** > > Hi Rajan, > >

RE: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread Rajan_Verma
e Else hasComment = False End If err: If err.Number <> 0 Then hasComment = False End If End Function From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Wednesday, August 03, 2011 12:54 PM To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread Venkat CV
Boolean* > > *On Error GoTo err:* > > *If cell.Comment.Text <> "" Then* > > *hasComment = True* > > *Else* > > *hasComment = False* > > *End If* > > *err:* > > *If err.Number <> 0 Then* > > *hasComment = False* > &g

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-03 Thread Venkat CV
Dear Ashish, Find attached Sample Worksheet with my requiremnt.. *Best Regards,* *Venkat* *Chennai* On Wed, Aug 3, 2011 at 12:01 PM, ashish koul wrote: > can you attach the worksheet > > > On Wed, Aug 3, 2011 at 11:11 AM, Venkat CV wrote: > >> Dear All, >> >> Let me know how to Vlookup Includ

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

2011-08-02 Thread ashish koul
can you attach the worksheet On Wed, Aug 3, 2011 at 11:11 AM, Venkat CV wrote: > Dear All, > > Let me know how to Vlookup Including Cell Comments..in Each Cells... > > > > *Best Regards,* > *Venkat* > *Chennai* > * > * > * > * > > > -- > > ---