SubscribeTo Method

Applies To

Range object.

Description

Macintosh only. Subscribes to a published edition.

Syntax

expression.SubscribeTo(Edition, Format)

expression Required. An expression that returns a Range object.

Edition Required String. The name of the edition to which you want to subscribe.

Format Optional Variant. Can be one of the following XlSubscribeToFormat constants: xlSubscribeToPicture or xlSubscribeToText.

See Also

CreatePublisher method.

Example

This example subscribes to the "stock data" publisher.

Worksheets("Sheet1").Range("D1").SubscribeTo "stock data"