FormulaLabel Property

Applies To

Range object.

Description

Returns or sets the formula label type for the specified range. Can be xlNone if the range contains no labels, or one of the following XlFormulaLabel constants: xlRowLabels, xlColumnLabels, or xlMixedLabels. Read/write Variant.

See Also

AcceptLabelsInFormulas property.

Example

This example topic sets the AcceptLabelsInFormulas property and then sets cells B1:D1 to be column labels.

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