Shapes.AddSmartArt Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Creates a new SmartArt graphic with the specified layout.

expression .AddSmartArt(Layout, Left, Top, Width, Height)

expression A variable that represents a Shapes collection.

Parameters

Name

Required/Optional

Data Type

Description

Layout

Required

SmartArtLayout

An object that represents the layout to use.

Left

Optional

Variant

The distance, in points, from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart).

Top

Optional

Variant

The distance, in points, from the top edge of the object to the top edge of the worksheet.

Width

Optional

Variant

The width, in points, of the object.

Height

Optional

Variant

The width, in points, of the object.

Return Value

Shape

Concepts

Other resources

Show: