How do I determine the size of an excel worksheet?

[Guest]

How do I determine the size of an individual worksheet in an Office Excel
2003 file? The Properties featue only tells me the size of the whole file.

 

[Frank Kabel]

Hi
not directly supported by Excel. One workaround: Export this sheet to a
separate workbook (with only this sheet) and measure its size

--
Regards
Frank Kabel
Frankfurt, Germany

How do I determine the size of an individual worksheet in an Office Excel
2003 file? The Properties featue only tells me the size of the whole

file.

 

[Don Guillett]

This will give you the filesize from a typed name in a cell such as

myfile

Sub filesize() 'FOR SELECTED
If ActiveCell.Value = "" Then Exit Sub
MsgBox " FILE SIZE IS " & Format(FileLen(ActiveCell & ".xls") *
0.0009767, "0") & " KB"
End Sub
The only way I know to get an accurate sheet size would be to make a copy
without the sheet and subtract.