This will give you the filesize from a typed name in a cell such as
Sub filesize() 'FOR SELECTED
If ActiveCell.Value = "" Then Exit Sub
MsgBox " FILE SIZE IS " & Format(FileLen(ActiveCell & ".xls") *
0.0009767, "0") & " KB"
The only way I know to get an accurate sheet size would be to make a copy
without the sheet and subtract.
"Frank Kabel" <email@example.com> wrote in message
> not directly supported by Excel. One workaround: Export this sheet to a
> separate workbook (with only this sheet) and measure its size
> Frank Kabel
> Frankfurt, Germany
> "rajivsahib" <firstname.lastname@example.org> schrieb im
> Newsbeitrag news:7031AE58-EB7A-44CD-9AF5-940BD47DAA8B@microsoft.com...
> > How do I determine the size of an individual worksheet in an Office
> > 2003 file? The Properties featue only tells me the size of the whole