MSHFlexgrid question

[Gimpster]

I was wondering if there is any way to detect the last row that has an entry in a certain column. Because I have a rather unique situation in which, I know that all of the rows that have an entry in a certain column will be at the top and all of the rows that have that column blank will be at the bottom. However, I need to know where that separation is made. Is there one simple function that will tell me that?

[Serge]

Check out TextMatrix property.

TextMatrix(Row, Column)....so let's say you want to get the value from last row and last column:

With MsFlexGrid
   MsgBox .TextMatrix(.Rows - 1, Cols - 1)
End With