Ah-ha! Thanks Robert. There is a property called 'Rows' and when I click on the ellipsis button for 'Rows' a list of sub-properties is revealed, one of which is 'VisibleRowCount' whose value is the correct number of visible rows, which in this case is 12.
I'm half-way there. I am using the value of 12 in a For loop so I now have the correct number of iterations but TC is still grabbing the values of rows that aren't visible. Normally I would use wValue to get the value of a cell in the grid but for this scenario I would need a method like 'wVisibleValue' which would grab the value of a cell in only the rows that are visible. I'm going to experiment with different methods but in the mean time if anyone has any suggestions.....
Chris
