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

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

"Peter Ostermann" wrote in message
...
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