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.
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.
