Maximum rows in Flex Grid control

[Nparag]

Hi everybody
I want to know what is the limit on the number of rows that we can fill in the Flex frid control.
If there is a limit on the number of rows can we trap if we are trying to add more rows tan those permitted by VB.
Also if anybody has idea about the limit on number of rows that can be entered in an excel sheet (excel 97)

Thanx in advance!

[Astinite]

From what I know of it there doesn't seem to be a limit to how many rows you can add to the flexgrid. I've added 66,000 rows to one, course it takes longer to add that many rows but it worked.

The limit to excel rows is 65,536.

[chris_henderson]

According to the MSDN help the Rows property is a long data type - ie approx +/- 2e09. So theoretically that is the max.
However, the number of cells (rows x cols)is also fixed by the machine memory. On my 128Mb machine I have managed to assign 350,000 cells with no problems.

Hope this helps.
Chris.