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 | Infrstaructure only |
Change | Occurs when something changes inside the named range control |
Deselected | Occurs when the selection moves from inside the namedrange control to an area outside |
Disposed | |
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
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext