VSTO - Excel - How to call range.Validation.Delete() without raising an error? RRS feed

  • Question

  • When I press Alt + Down keys before calling range.Validation.Delete(), the Excel shows the following error:

    An exception of type 'System.Runtime.InteropServices.COMException' occurred in mscorlib.dll but was not handled in user code

    Additional information: Exception from HRESULT: 0x800AC472

    If there is a handler for this exception, the program may be safely continued.

    How can I prevent this error in an asynchronous method?

    Any help would be appreciated.

    Friday, August 17, 2018 7:31 PM