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