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

ISFORMULA(rgeCell)

 
 

Returns whether a particular cell contains a formula.

 

 
rgeCellThe cell you want to check.
 

 

REMARKS

 
 

  • Calling this function IsFormula rather than HasFormula is in keeping with other Excel functions.

    		 

     
    1
    2
    3
    4
    5
    6
    7
    8
    Option Explicit

    Public Function ISFORMULA(ByVal rgeCell As Range) As Boolean

       Call Application.Volatile(True)

       ISFORMULA = rgeCell.HasFormula
    End Function
    		   

     

    Example

    		 
       

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