Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions User Defined > ROWHEIGHT< Previous | Next > 
 

ROWHEIGHT([iRowNo])

 
 

Returns the row height of the active cell.

 

 
iRowNoThe row number you want the height of.
 

 

REMARKS

 
 

  • ??

    		 

     
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    Option Explicit

    Public Function ROWHEIGHT(Optional ByVal iRowNo As Integer = -1) As Single

       Call Application.Volatile(True)

       If iRowN = -1 Then
          ROWHEIGHT = ActiveCell.RowHeight
       Else
          ROWHEIGHT = ActiveSheet.Rows(iRowNo & ":" & iRowNo).RowHeight
       End If

    End Function
    		   

     

    Example

    		 


     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >