wks.DC.Valid

Valid

Syntax

wks.DC.Valid

Access

Read/write

numeric

Description

Check the status of Data Connector added to the worksheet:

0 = has no Data Connector,

2 = worksheet has not been used as destination by any Data Connector,

3 = worksheet is the destination of a Data Connector. You can then use "wks.DC.Source$" to check its data source.

4 = Data Connector has an invalid data source.

5 = source changed.

Examples