Results 1 to 3 of 3

Thread: How to know height of row in Excel?

  1. #1
    Join Date
    Nov 2011
    Posts
    61

    How to know height of row in Excel?

    hello everyone,

    I want to know height of row in cm as function CELL return width column...

    Thanks a lot.

  2. #2
    Join Date
    Aug 2011
    Posts
    540

    Re: How to know height of row in Excel?

    Be aware that the column width argument from the CELL function is in number of characters, not in CM.

    To get row height in CM, you may use a User Defined Function.

    • To enter this User Defined Function (UDF), <alt-F11>
    • opens the Visual Basic Editor.
    • Ensure your project is highlighted in the Project Explorer window.
    • Then, from the top menu, select Insert/Module and
    • paste the code below into the window that opens.


    • To use this User Defined Function (UDF), enter a formula like

    Code:
    =RowHeightCM([cell_ref])
    in some cell.

    If the optional cell reference argument is missing, the function will return the row height of the cell in which it was entered (like the CELL function). Note that the rowheight property is in points, and there are 72 points to an inch.

    Code:
    Option Explicit
    Function RowHeightCM(Optional rg As Range) As Double
    If rg Is Nothing Then Set rg = Application.Caller
    RowHeightCM = rg.RowHeight * 2.54 / 72

  3. #3
    Join Date
    Aug 2011
    Posts
    580

    Re: How to know height of row in Excel?

    You can also use the following VBA funcation to get the requirement of yours.
    Sub Change_Header_Row_Height()

    Code:
    MsgBox "RowHeight = " & Range("A1").RowHeight _
    & vbCrLf & "Height = " & Range("A1").Height
    
    Range("A1").RowHeight = 90
    
    End Sub

Similar Threads

  1. Autofit Row height is not working in Microsoft Excel 2007
    By SadyQ in forum MS Office Support
    Replies: 4
    Last Post: 24-01-2012, 12:25 PM
  2. How to adjust tab height in Firefox 8
    By Kanesteyn in forum Technology & Internet
    Replies: 4
    Last Post: 03-12-2011, 03:22 PM
  3. MAX width and max height of a image using css
    By Rutajit in forum Software Development
    Replies: 2
    Last Post: 22-05-2009, 07:00 PM
  4. Bug in the Iframe height related to IE8
    By Janhavi4U in forum Windows Software
    Replies: 4
    Last Post: 30-01-2009, 10:57 PM
  5. Variable height in CSS
    By Sentential in forum Software Development
    Replies: 8
    Last Post: 22-10-2008, 02:21 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,638,480,888.71147 seconds with 17 queries