Hello,
I want to display row height in inches in a cell (the same value displayed when using page layout mode), and i want to do the same with column width.
I have a code:but it displays values in characters for columns and points for rows.Function Width(MyRange As Range) As Double Application.Volatile Width = MyRange.ColumnWidth End Function
Function Height(MyRange As Range) As Double Application.Volatile Height = MyRange.RowHeight End Function
Can anyone help me?
Thanks
Bookmarks