WorksheetDataCol Property

The WorksheetDataCol property returns or sets the Data column for tick mark labels when Worksheet is the Label source. Returns a Long.

Syntax

object.WorksheetDataCol

object.WorksheetDataCol = WorksheetDataCol

 

Parameter	Type	Description
WorksheetDataCol	Long	required, default = 1 (column A)

 

Remarks

Set the Mode property to grfLabelsWorksheet before using this command. Set the label column with the WorksheetLabelCol property.

Example

This example shows how to specify the data column for tick mark labels from the worksheet.

TickLabels.WorksheetDataCol = 1

 

Used by: AutoAxisTickLabels object