AcceptLabelsInFormulas Property

Applies To

Workbook object.

Description

True if labels can be used in worksheet formulas. The default value is True. Read/write Boolean.

See Also

FormulaLabel property.

Example

This example sets the AcceptLabelsInFormulas property for the active workbook and then sets cells B1:D1 on worksheet one to be column labels.

ActiveWorkbook.AcceptLabelsInFormulas = True
Worksheets(1).Range("b1:d1").FormulaLabel = xlColumnLabels