Worksheet - NamedRange

Event	Description
BeforeDoubleClick	Occurs when the namedrange control is double clicked. This occurs before the double click.
BeforeRightClick	Occurs when a namedrange control is right clicked
BindingContextChanged	Occurs when the binding of the Named Range changes
Change	Occurs when something changes inside the named range control
Deselected	Occurs when the selection is moved outside the Named Range
Disposed	Occurs when the Named Range is disposed of. Typically raised by garbage collection.
Selected	Occurs when the namedrange control is selected
SelectionChange	Occurs when the selection moves inside the namedrange control

This list is slightly different to the VBA Events

You can create NamedRanges dynamically.

Microsoft.Office.Tools.Excel.NamedRange AddNamedRange( 
   Microsoft.Office,Interop.Excel.Range range, 
   string name)

Public Function AddNamedRange( _ 
   ByVal range As Microsoft.Office.Interop.Excel.Range. _ 
   ByVal named As String) As _ 
   Microsoft.Office.Tools.Excel.NamedRange