All depends on memory
One worksheet within a workbook has 16,777,216 cells and can therefore
theoretically have 16,777,216 formulas (depending on memory).
One workbook can have as many worksheets as you want.
To get the number of cells in a worksheet, the following VBA will give you
the total formulas in the active worksheet...
application.Range("A1:IV65536").SpecialCells(xlCel lTypeFormulas).Count
HTH,
--
Gary Brown
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
"RichardZ" wrote:
I am wondering what the maximum number of calculation that excel can make per
workbook? Where do I look to see current number of calculations?