Finding out range size etc

[pluto]

I need a macro that calculates how many rows and columns a highlighted range covers.

so if I mark a single block of cells with the mouse and run the macro it tells me details of the range.

Can anybody help with this one?

[Sarrina_D]

You can do the read-only properties...

MsgBox Selection.Count

For the Column/Row Breakdown -

MsgBox Selection.Columns.Count
MsgBox Selection.Rows.Count

Hope that's helpful...

Sarr