I'm new on QTP, but i thing its depending on the sheet you're using.
If you use the GlobalSheet, you can write:
DataTable.SetCurrentRow (6)
For more Information take a look at:
https://www.learnqtp.com/qtp-and-excel-part1/
https://www.learnqtp.com/qtp-and-excel-part2/
https://www.learnqtp.com/qtp-and-excel-part3/
I hope this helps...
If you use the GlobalSheet, you can write:
DataTable.SetCurrentRow (6)
For more Information take a look at:
https://www.learnqtp.com/qtp-and-excel-part1/
https://www.learnqtp.com/qtp-and-excel-part2/
https://www.learnqtp.com/qtp-and-excel-part3/
I hope this helps...