Size of worksheets

P

Peter Ostermann

Hi, folks,

I like to know which one of the 50 worksheets
in my workbook is causing the size of a few
MB. Is there any VBA method to find that out?

Information about how many cells in each sheet store data
is no help, because of graphic elements in
the sheets.

Regards
Peter
 
C

Charles Williams

Use Application.memoryused to measure the amount of memory being used, and
delete the worksheets one by one, measuring memory each time.
This will give you a good approximation unless you have an unusually high
number of interworksheet links.

regards
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com
 

Ask a Question

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.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Change font size of header on every sheet? 4
Renaming worksheets 2
VBA code for pasting links -- modifying RDB code for summary workbook 10
hide multiple worksheets based on a formula value in one cell 1
Combining Multilple Worksheets Into One 6
Summary worksheet 4
Copy Dynamic Range problem 2

Top