Quick way of identifying Worksheet size

[Corleone]

Afternoon all, is there a quick way of doing the above

one of our contractors is having problems with one of our excel spreadheets in that when he runs a particular macro the file expands to 13mb, as opposed to around 6mb/7mb which it has been for over a year after every update.

I cannot see anything obvious as to why it is expanding. - there are around 20 worksheets on it.

my questions is, is there a way of viewing each of the worksheet sizes that make up the entire workbook?

at least then i can pinpoint where the issue is

thanks

 

[JackDanIce]

I don't believe you can individually assess the size of each worksheet within a workbook, however, if you select each worksheet one by one in the workbook, then press CTRL+END it will take you to what the worksheet thinks is the last used cell in the sheet. Quite often, when a workbook's size suddenly grows, it's because the used range has expanded (for no apparent reason). Any unsed rows/columns should be deleted and the file then saved and you should see the file size then decrease.

At a guess, the macro is either taking data from another source, pasting it and this is including non-used data but making the destination workbook believe it is part of a used range or some variable in the macro code is larger than it should be.

 

[Corleone]

cheers, ill have a look at doing it this way