Occurs when a formula or sheet being moved or copied contains the defined name, which already exists on the destination worksheet or workbook.
The DefinedNameConflictResolving event handler receives an argument of the DefinedNameConflictResolvingEventArgs type. The following properties provide information specific to this event.
Gets or sets a value indicating whether the event should be canceled.
(Inherited from CancelEventArgs)
|NameStatus||Gets the status of the conflict name.|
|NewName||Gets or sets the name for a new version of the defined name being moved or copied.|
|OldName||Gets the defined name for which the event is fired.|
|UsedNames||Provides access to the set of table and defined names existing in the destination workbook.|
|UseExistingName||Gets or sets a value indicating whether to use the defined name specified on the destination worksheet or workbook in the conflict situation.|
|Validator||Gets or sets a validator used to check whether a new version of the conflict name is valid and unique.|
Any other suggestions? Tell us here.