| XlFormulaLabel can be one of these XlFormulaLabel constants. |
| xlColumnLabels |
| xlMixedLabels |
| xlNoLabels |
| xlRowLabels |
expression.FormulaLabel
expression Required. An expression that returns one of the objects in the Applies To list.
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