last array value

[MeCoOp]

This seems like a simple problem but the solution escapes me.  I am currently reading data from an excel spreadsheet.  If I wanted to read data from from the last cell in a column or the last point in a 1D array, how would I go about doing so.  The location of the point I'm interested will be dependent upon the length of the test so I can't simply index it.  Any suggestions?

[Dennis_Knutson]

For Excel, there's a range property you can use. One example can be found here. If you need other examples, search for forum for Excel and range. To determine the last element in a LabVIEW array, use Array Size and subtract 1 from it.

[MeCoOp]

The array size and subtract 1 solution worked.  Thanks a bunch for your help.