Highlight a row in table

[MartinI]

I have loaded a spreasheet file into a table and the data is displayed correctly.

I am now trying to highlight the first row of data  in the table - do something -  then the second  row etc. This should ideally be from a loop counter.

Any ideas?

[AndrewAlford]

This will highlight 6 columns in a row, then increment to the next row. You could also use the BG color of the cell to get a more dramatic highlight effect.

Message Edited by AndrewAlford on 02-03-2006 08:58 AM

[RSibagatullin]

I've tried the above code and it works. In my case not all the rows of a big table are visible  so I have a vertical scroller. How do I make sure that every time i highlight the row it is visible to the user. Basically I need to automatically scroll through the table so the highlighted row is visible to the user. Any ideas about that?
Thanks.

[lmtis]

Use the index values property to set the visible lines.

[AndrewAlford]

Use the property IndexVals (Index Values), this sets the column and row that is first in the upper left corner of the table.