Getting cell count

[rafik2k10]

In terms of performance which method is preferable to get the cell count for the larger file:

worksheet.Cells.CountLarge
Or
Calculate using: worksheet.Cells.MinRow - MinColumn - MaxRow - MaxColumn
Or
worksheet.Cells.MaxDisplayRange.CellCount

[Amjad_Sahi]

@rafik2k10,

Thanks for your query.

Well, Cells.CountLarge is the best one for performance wise.

[rafik2k10]

Thanks for the detail.

[Amjad_Sahi]

@rafik2k10,

You are welcome.