Hi Tom,

I wasnt actually seeking to find out what the limitations are, but rather is
the workbook approaching or exceeding these limitations.
ie how many formulas are in use, how many formats are used in the workbook,
how many fonts are used in the workbook and so on

"Gary B" wrote:

I am aware that Excel has some built in limitations 32,000 iterations etc.

Is there some code I can run over a workbook that will report on each of
these limitations (all internal limitations)? Ie formulas, colours used,
formats and fonts used etc ?

Thanks in advance.

Gary