How do I determine the size of an excel worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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