Sheet size (MB)?

[brisbane bob]

Is there a simple way of seeing how much space (in MB) each sheet is taking up in am Excel Workbook?

 

[Michael M]

Hi Bob
I'm sure there is a VBA way to do this, but in the past I have resorted to saving the entire sheet to a new workbook and then looking at it's file size.

HTH
Michael M

 

[brisbane bob]

My ususal method is to save it in another name and delete the sheets one by one, but that is painful with a lot of sheets.

You're right - there must be some VBA method.

 

[dave3009]

Why not run the VBA recorder while you delete and save the sheets, then change the sheet name each time you do it.

 

[brisbane bob]

It still involves saving and closing the workbook, re-opening it and manually recording the new file size. Unless I'mm doing it the hard way...

 

[dave3009]

good point, but it'd get you started

 

[brisbane bob]

Being inherintly lazy with a default to bone idle, I'm looking for a quick way - and there's the challenge as well....