-
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?
-
Check out TextMatrix property.
TextMatrix(Row, Column)....so let's say you want to get the value from last row and last column:
Code:
With MsFlexGrid
MsgBox .TextMatrix(.Rows - 1, Cols - 1)
End With