How do I determine the size of an excel worksheet?

R

rajivsahib

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.
 
F

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

rajivsahib said:
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
Click to expand...
file.
 
D

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.
 
Top