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