Re: $$Excel-Macros$$ vba code instr - help to understand it

2011-06-26 Thread STDEV(i)
its look like to extrac a* list of unique values *form Range Rng1 CMIIW On Mon, Jun 27, 2011 at 6:24 AM, netuser1110 wrote: > Hi, > > Does anyone can explain me what this loop does and more specificly the > "InStr" function the way it is used below : > > For Each Cel In Rng1 > If Len(

Re: $$Excel-Macros$$ vba code instr - help to understand it

2011-06-26 Thread Vasant
Hi syntax : InStr( [start], string_being_searched, string2, [compare] ) searches for (lowercase value of in cell 'Cel' concatenated with '«') in TmpX On Mon, Jun 27, 2011 at 4:54 AM, netuser1110 wrote: > Hi, > > Does anyone can explain me what this loop does and more specificly the > "In