Worksheet - NamedRange

EventDescription
BeforeDoubleClickOccurs when the namedrange control is double clicked. This occurs before the double click.
BeforeRightClickOccurs when a namedrange control is right clicked
BindingContextChangedInfrstaructure only
ChangeOccurs when something changes inside the named range control
DeselectedOccurs when the selection moves from inside the namedrange control to an area outside
Disposed 
SelectedOccurs when the namedrange control is selected
SelectionChangeOccurs 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


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext