IsSimpleReferenceFormula Property

Gets the value indicating whether the Formula is a simple formula referring to a single cell, a single region, or multiple regions in the same workbook as the named reference.

Syntax

Visual Basic

'Declaration
 
Public ReadOnly Property IsSimpleReferenceFormula As Boolean

C#

public bool IsSimpleReferenceFormula {get;}

Remarks

If the reference is surrounded by parentheses or whitespace or the named reference has some other complex formula this will return false.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2