AnchorPosition Property

Gets/sets the Anchor's position in the Worksheet. This position is determined by a StartingElement and an EndingElement, which sets a CellRange. For it to work, the CellRange must be located within the same Worksheet as the Picture.

Syntax

Visual Basic
C#

'Declaration

 

Public Property AnchorPosition As CellRange

'Usage

 

Dim instance As Picture

Dim value As CellRange

 

instance.AnchorPosition = value

 

value = instance.AnchorPosition

public CellRange AnchorPosition {get; set;}

Remarks

The StartingElement is the address corresponding to the inner top left corner of the top left Cell in the CellRange.

The EndingElement is the address corresponding to the outer top left corner of the bottom right Cell in the CellRange.

For example, if the range determined by the addresses "A2 : E5", the Picture starts at the inner top left corner of the A2 Cell and pass through it until it reaches the outer corner of the E5 Cell, which it will only touch and not pass through.

Note that the StartingElement and EndingElement can also have the same value. In that case, a OneCellAnchor will be created.

Also note that setting a value in this property will remove the value in the AbsolutePosition property because an anchor using the AbsolutePosition property is an AbsoluteAnchor, which doesn't use the AnchorPosition property.

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, 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

Reference

Picture Class
Picture Members