VerticalRepeat Property

Microsoft Publisher Visual Basic

Show All Show All

VerticalRepeat Property

Returns a Long that represents the number of times the catalog merge area will repeat down the target publication page when the catalog merge is executed. Read-only.

expression.VerticalRepeat

expression    Required. An expression that returns a CatalogMergeShapes object.

Remarks

When the catalog merge is executed, the catalog merge area repeats once for each selected record in the specified data source.

The number of times the catalog merge area repeats down the page is determined by the height of the area. Use the Height property of the Shape object to return or set the vertical size of the catalog merge area.

The HorizontalRepeat property of the CatalogMergeShapes object represents the number of times the catalog merge area repeats horizontally across the target publication page.

Example

The following example returns the number of times the catalog merge area will repeat horizontally and vertically on the target publication page when the catalog merge is performed. This example assumes the catalog merge area is the first shape on the first page of the specified publication.

    Sub CatalogMergeDimensions()
       
    With ThisDocument.Pages(1).Shapes(1)
        Debug.Print .Width
        Debug.Print .CatalogMergeItems.HorizontalRepeat
        Debug.Print .Height
        Debug.Print .CatalogMergeItems.VerticalRepeat
    End With

End Sub