Excel Macro: is it possible to find Row heights and Column widths of a worksheet?

Question

Is there any way of finding the height of the ROWS from 1 to 50, and the width of the COLUMNS from A to Z in an Excel sheet without manually clicking and writing down the answer?

Thanks

Michael.

Answer 1

To add on top of @Parkyprg

Range("A1:A50").Height      ' height of range
Range("A:Z").Width          ' width of range
Range("A1:A50").Rows.Count  ' number or rows in range
Range("A3").Height          ' height of A3 cell
Range("A3").Width           ' width of A3 cell