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(
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
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(Cel) > 0 Then
If InStr(1, TmpX, LCase(Cel) & Chr(171)) = 0 Then
TmpX = TmpX & LCase(Cel) & Chr(171)
n = n + 1:
