This topic has not yet been rated - Rate this topic

NamedRange.ShowPrecedents Method

Visual Studio 2010

Draws tracer arrows to the direct precedents of the NamedRange control.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

Object ShowPrecedents(
	Object Remove
)

Parameters

Remove: Type: System.Object
true to remove one level of tracer arrows to direct precedents; false to expand one level of tracer arrows. The default value is false.

Return Value

Type: System.Object

Remarks

The NamedRange control must be a single cell.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example makes cell A1 a precedent of a NamedRange. The example then uses the ShowPrecedents method to draw an arrow between the NamedRange and the precedent cell.

This example is for a document-level customization.


private void DisplayPrecedents()
{
    this.Range["A1", missing].Value2 = 1710;

    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["C1", missing],
        "namedRange1");
    namedRange1.Value2 = "=A1";
    namedRange1.ShowPrecedents(false);
}

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD