<div>
This may help.<br />
<br />

<pre><code id="code-20-40485197-1">Function Height(ByRef MyRange As Range)
    Height = MyRange.EntireRow.Height
End Function

Function Width(ByRef MyRange As Range)
    Width = MyRange.EntireColumn.Width
End Function</code></pre>
</div>


This may help.



Function Height(ByRef MyRange As Range)
    Height = MyRange.EntireRow.Height
End Function

Function Width(ByRef MyRange As Range)
    Width = MyRange.EntireColumn.Width
End Function

<div>
Column width is available in the CELL function:<br />
<br />
=CELL(&quot;width&quot;,CellRef)<br />
<br />
If CellRef is left blank it will use the column in which it is placed.<br />
<br />
This only gives the width as an integer, so if the width is set to 8.71 it will show 9.<br />
<br />
Unfortunately, no such option within the CELL function for height.<br />
<br />
Thanks<br />
Rob H
</div>


Column width is available in the CELL function:

=CELL("width",CellRef)

If CellRef is left blank it will use the column in which it is placed.

This only gives the width as an integer, so if the width is set to 8.71 it will show 9.

Unfortunately, no such option within the CELL function for height.

Thanks
Rob H

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
<b>Does Excel (2013) have a formula which displays the height of the row it's in (or width of its column)?</b><br />
<br />
For example, the two functions:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; =ROW()<br />
&nbsp; &nbsp; &nbsp; &nbsp; =COLUMN()<br />
<br />
display the row &amp;&nbsp;column numbers of a given cell. I'm interested in finding the height &amp;&nbsp;width (ie something like this):<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; =HEIGHT()<br />
&nbsp; &nbsp; &nbsp; &nbsp; =WIDTH()<br />
<br />
I realize the above functions do not exist but that's essentially what I'm after.<br />
<br />
<b>If Excel functions are not available, then is it possible using VBA?</b><br />
<br />
Thanks
</div>
</div>


Hello,

Does Excel (2013) have a formula which displays the height of the row it's in (or width of its column)?

For example, the two functions:

        =ROW()
        =COLUMN()

display the row & column numbers of a given cell. I'm interested in finding the height & width (ie something like this):

        =HEIGHT()
        =WIDTH()

I realize the above functions do not exist but that's essentially what I'm after.

If Excel functions are not available, then is it possible using VBA?

Thanks

Display the height of a given row in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.