Labview2015, Excel, obain multi-address at the same time

[Erbin]

   Hi guys, I try to use ActiveX to obain cell's address of specific data, but only get one result in a running.

   I hope obain Multi-address for some specific in a VI at the same time.

   It is a VI that obain one result in one run below.

   Thanks & Best Regards.

[PazhanivelVenkatt]

how about using Loop to iterate and get all required addresses

[Erbin]

Thanks PalanivelT, let me try.

[ben64 · Accepted solution]

All the string manipulation at the end is useless (and very Rube Goldberg). Just connect a FALSE constant to the Row Absolute and Column Absolute inputs of the the Range Address method and it will return B16 instead of $B$16.

You will need to use a criteria to stop your loop because the Find Next method will cycle continuously throught the range. Usually you cycle while the found address is different from the first address found.

Finally, you will have to filter error 97 which is thrown when no match is found (and use it to stop cycling throught the range).

Ben64