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...
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.