Need to flag the lead ID of any contiguous ID's from a sortedlist of ID's.
Extending my test list with real ID's resulted in new cases not resolved as expected.
I am thinking of first testing the ID length
if Len(rngC) = rngC.Offset(-1, 0) then
The serie of ifs testing, or a Select Case
If trailing Alpha ...
if trailing Numeric...
etc...
Else
The serie of ifs testing, or a Select Case
End if
Can you please give your advice ?
Thank you again.
My extended list follows
111
112
115
115A
123
250A
250B
300A1
300A2
008F009A
008F009B
011001
011002
011033
011034
0251247
025172
025174
|