Hi Simon,

You could use:
=INFO("memused")
in an otherwise empty wb before loading the wb you want to test, then:
1. open the wb you want to test;
2. update the calculation; and
3. calculate the difference.

--
Cheers
macropod
[Microsoft MVP - Word]


"Simon" wrote in message ...
Is it possible to get an estimate of the file size of a spreadsheet by
individual worksheet?

I cannot think of a worksheet property that would contain this, so I assume
that one needs to count sheet elements and apply a per-object memory value
(this only needs to be an estimate) to get the estimat.

Any help would, as always, be much appreciated

Thanks in advance


Simon