ASAP utilities have nice macro that shows you all the info about the
file. And it is free for home use!
http://www.asap-utilities.com/
Shows statistics of the current file and your selection.
􀂃 filename
􀂃 file size
􀂃 file date
􀂃 number of sheets
􀂃 active sheet name
􀂃 address of the used range
􀂃 last row number of the used range
􀂃 last column number of the used range
􀂃 total cells in the used range
􀂃 formulas in the used range
􀂃 blanks in the used range
􀂃 constants in the used range
􀂃 errors in the used range
􀂃 logical values in the used range (true/false)
􀂃 text cells in the used range
􀂃 numeric cells in the used range
􀂃 address of active cell
􀂃 column number of active cell
􀂃 row number of active cell
􀂃 address of selected range
􀂃 amount of columns in selected range
􀂃 amount of rows in selected range
􀂃 amount of cells in selected range
