ActiveX

To specify the maximum number of rows when using virtual mode

Set the VirtualMaxRows property as follows:

• If you know the exact number of rows in the sheet or bound database, specify that number.
• If you do not know the exact number of rows in the sheet or bound database, but would like the sheet to determine it once it has read all the rows, specify –1.
• If you do not know the exact number of rows in the sheet or bound database, but would like to estimate it, overestimate the number rather than underestimating it.
  If you underestimate the number, the sheet never reads the records past the value you assign.