Forum Discussion

Karinh395's avatar
Karinh395
Copper Contributor
Jan 29, 2024

Microsoft Visual Basic for Applications System Error &H8000FFFF (-2147418133). Catastrophic failure.

Hi All:   I created a spreadsheet with the following VBA: Function SumColor(MatchColor As Range, sumRange As Range) As Double Dim cell As Range Dim myColor As Long myColor = MatchColor.Cells(...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jan 31, 2024

Karinh395 

The error you are encountering, "Microsoft Visual Basic for Applications System Error &H8000FFFF (-2147418133). Catastrophic failure," can sometimes occur due to issues with the VBA environment or conflicts with other applications. Here are some suggestions to troubleshoot and resolve the issue:

  1. Close and Reopen Excel:
    • Close Excel completely.
    • Reopen Excel and open the spreadsheet with the VBA code.
  2. Check for ActiveX Controls:
    • Ensure that there are no ActiveX controls or form controls causing conflicts.
    • Remove any unnecessary ActiveX controls or form controls.
  3. Macro Security Settings:
    • Check your macro security settings to make sure that macros are enabled.
    • Go to the "Developer" tab, click "Macro Security" in the "Code" group, and ensure that it's set to a level that allows macros to run.
  4. Compile VBA Code:
    • Open the VBA editor (Alt + F11).
    • In the VBA editor, go to "Debug" and choose "Compile VBAProject."
    • Check for any compilation errors.
  5. Remove Recently Installed Add-ins:
    • If you've recently installed any Excel add-ins, try disabling or removing them to see if the issue persists.
  6. Update Excel:
    • Ensure that your Excel application is up to date. Check for and install any available updates.
  7. Reset Excel Settings:
    • As a last resort, you can try resetting Excel settings. Note that this will reset all customizations.
      • Close Excel.
      • Press Windows key + R to open the Run dialog.
      • Enter %appdata%\Microsoft\Excel and press Enter.
      • Rename the "XLSTART" folder to something else (e.g., "XLSTART_backup").
      • Restart Excel.

If the issue persists after trying these steps, it may be necessary to investigate further or seek assistance from Microsoft Support. Additionally, if the Catastrophic Failure error persists, there might be deeper issues with your Excel installation, and you may need to repair or reinstall Microsoft Office. The text and steps were edited with the help of AI.

 

The steps provided are generally applicable to various versions of Microsoft Excel, including Excel 2016, 2019, and Excel for Microsoft 365. However, some specific features or menu locations might vary slightly between versions. Remember, these instructions are general, and some details may vary based on your specific Excel version.

 

If none of these steps help you, I recommend adding more information to your topic. Information such as Excel version, operating system, storage medium, file extension, etc.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

Resources