Getting rows and columns in flexgrid

[CoMMiE]

Hi all
is there a way for me to get the row the col of the flexgrid everytime i load the program?

i need to do this because the size of the flexgrid changes acording to the user query

Thanks in advance

Hello there,

Try something like this

Private Sub Form_Load()
  
  Dim iCol As Integer, iRow As Integer
    
  iCol = MSFlexGrid1.Cols
  iRow = MSFlexGrid1.Rows
  
  MsgBox iCol & " " & iRow
  
End Sub

Hope this helps,

[CoMMiE]

Thanks for the help RvA
That code really helps