Is there any way to show the size of individual sheets within a workbook?

Thanks

"Steve Slack" wrote in message
...
Is there any way to show the size of individual sheets within a workbook?

Thanks

What do you mean by "size"?
If you mean how many rows and columns, CTRL+END will take you to the "last
used cell" on a worksheet.
However, I suspect you may mean "file size". An individual worksheet is not
a file, so doesn't have a file size. You could get an idea of relative sizes
by copying each sheet to a separate workbook and saving, but it would only
be a very rough idea.

Size in Mb of each sheet...
Total file size of workbook is about 40Mb (yes it is big!) with about 30
individual sheets, each either doing calculations, or holding reference
data..

Bit of a drag to copy each sheet to see the size, especially since it's
so slow on the recalculations!

Need to reduce the size of the workbook as a whole, so need to see which
sheets are the biggest, so I can do something about them.

I remember seeing a size of sheet indicator but I can't remember where -
possibly in a VBA screen?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!