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

Karinh395 

The "Microsoft Visual Basic for Applications System Error &H8000FFFF (-2147418133). Catastrophic failure." error you're encountering can be frustrating, but there are a few reasons it might be happening in your specific case. Here are some things to try:

1. Check for "Workbook_Open" event code:

• Open the VBA editor (Alt + F11).
• In the Project Explorer, expand your workbook and look for a module named "ThisWorkbook."
• Double-click "ThisWorkbook."
• Check if there's any code in the "Workbook_Open" event procedure.
• If there is, try commenting it out (adding ' in front of each line) or deleting it. Sometimes rogue code in this event can trigger errors when opening the workbook.

2. Verify references:

• Go to Tools > References in the VBA editor.
• Look for any unfamiliar or unnecessary references listed.
• Try unchecking those references and see if the error persists. Sometimes unexpected references can cause crashes.

3. Clear compiled code:

• Go to Tools > VBAProject Properties.
• Select the "Compile" tab.
• Click the "Clean" button under "Compile options."
• This will clear any cached compiled code and force it to be rebuilt next time you run the macro.

4. Debug the code:

• Set breakpoints within your "SumColor" function at key points like the loop or conditional statement.
• Run the macro in step-by-step mode (F8 key) and see if you can identify any suspicious behavior or errors within the code.

5. Consider alternative approaches:

• If the function only needs to check the first cell in "MatchColor" for color, consider simplifying the code by directly comparing the color instead of looping through cells.
• You can also explore using built-in Excel functions like SUMIF or SUMPRODUCT that might achieve the same result without needing custom VBA.

Additional Tips:

• Make sure you have the latest updates installed for both Excel and VBA.
• Try opening the workbook in Safe Mode (holding Ctrl while opening Excel) to see if any add-ins are causing the issue.
• If none of these suggestions work, consider sharing the full code of your "SumColor" function and any other relevant VBA code for further analysis.

Remember, troubleshooting VBA errors can be tricky, but by testing and analyzing different possibilities, you should be able to pinpoint the cause and fix the problem.

I hope this helps!