Pictures Method

Applies To

Chart Object, DialogSheet Object, Worksheet Object.

Description

Accessor. Returns an object that represents a single picture (a Picture object, Syntax 1) or a collection of pictures (a Pictures object, Syntax 2) on the sheet. Read-only.

Syntax 1

object.Pictures(index)

Syntax 2

object.Pictures

object

Required. The object containing the pictures.

index

Required for Syntax 1. The name or number of the picture.

Example

This example deletes every picture on Sheet1.


Worksheets("Sheet1").Pictures.Delete

This example changes the color of the border of picture one on Sheet1 to red.


Worksheets("Sheet1").Pictures(1).Border.ColorIndex = 3