find in a collection 1

[sal21]

I fil a collection with:

....
TROVA = RIGA & "-" & COLONNA & "-" & GIORNO & "-" & NOMINATIVO & "-" & NUMCELLULARE
Debug.Print TROVA
COLLETT.Add Key:=TROVA, Item:=TROVA
....

in debug.print during the filling of colection i can have:

1-1-01/08/2022-ARTURO-(+39)-78678611
1-2-01/08/2022-ARTURO-(+39)-78678611
1-3-01/08/2022-ARTURO-(+39)-78678611
1-4-01/08/2022-ARTURO-(+39)-78678611
1-5-01/08/2022-ARTURO-(+39)-78678611
1-6-01/08/2022-ARTURO-(+39)-78678611
1-7-01/08/2022-ARTURO-(+39)-78678611

now i have a varcol=1 and varrow=4, how to return the complete element of connection, based this two var?

in my case:
1-4-01/08/2022-ARTURO-(+39)-78678611

note:
the lenght of the first two char in element are varible. for example i can have also:

31-74-01/08/2022-ARTURO-(+39)-78678611
188-7-01/08/2022-ARTURO-(+39)-78678611

 

[strongm]

Quick question: why, if you need to reference by row and column, are you using a collection?

 

[combo]

Aside of Strongm's question, why not (if unique) [tt]Key:= RIGA & "-" & COLONNA[/tt] ?

combo

 

[2009luca]

Tks.
Infact now i use

Key:= RIGA & "-" & COLONNA

 

[Andrzejek]

YES have two account...
for future i can use only one.
sorry

That did not last long...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[strongm]