for a tool which can calculate this (not for free - and I
personally haven't use this).
If you want to do it on your own, AFAIK there's no direct
information for getting the size of an individual
worksheet. What you can do in a macro:
- create a blank new workbook#
- get the size of this blank workbook
- copy your worksheet to this new workbook
- measure again the size of this workbook
- repeat for all worksheets
Hi Les,
Saveas, Save each worksheet as a separate workbook http://www.mvps.org/dmcritchie/excel/saveas.htm
will enable you to check the size. The individual workbook
isn't likely to function by itself, but by looking in the
directory you created them in you will see the size.
See yellow box at end of document if you've not installed
used a macro before.
