ExcelName Element (Microsoft Excel)

Contains the name of a range of cells, usually represented by a formula.

Contained In

XML

Subelements

Formula, FunctionGroup, Hidden, KeyboardShortcut, Macro, Name, SheetIndex

Remarks

The Name and Formula subelements are required, and all other subelements are optional.

Examples

This example assigns the name "Rates" to the range E1:E4 on Sheet1. The name does not appear in the Define Name dialog box in Microsoft Excel.

 <x:ExcelName>
  <x:Name>Rates</x:Name>
  <x:Formula>=Sheet1!$E$1:$E$4</x:Formula>
  <x:Hidden/>
  <x:SheetIndex>1</x:SheetIndex>
 </x:ExcelName>

This example assigns the name "States" to the range B1:B5 on Sheet1. The name does not appear in the Define Name dialog box in Microsoft Excel.

 <x:ExcelName>
  <x:Name>States</x:Name>
  <x:Formula>=Sheet1!$B$1:$B$5</x:Formula>
  <x:Hidden/>
  <x:SheetIndex>1</x:SheetIndex>
 </x:ExcelName>