Measurement Studio for VB6

cancel
Showing results for 
Search instead for 
Did you mean: 

Getting line index from Excel files

Hello
 
Does anybody knows a Excel API function to read the line index of a cell in a Excel file?
I'm using the "Microsoft Excel 9.0 Object library" wich I included as instrument
to automatize Excel.
Thanks in anticipation.
0 Kudos
Message 1 of 2
(6,719 Views)
I'm not if this is exactly what you are looking for, but it should at least get you in the right direction.  There is a .Row property that you can call on a Range object which will return the index of the first row of the selected Range.  If your Range is a single cell, it will thus return the row index of that cell.
0 Kudos
Message 2 of 2
(6,710 Views)