2

I have a userform on my spreadsheet which crashes excel and shows an Excel "System error &h8000ffff (-2147418113)" error message if I open the uf after copying and pasting data to several sheets. However if I open the uf immediately after opening the file it doesn't crash Excel. There is no code in the init function or any add-ins. I think the problem could be due to the data copy/analyze/paste functions which repeatably update a few tables, they run ok if i activate the sheet to be updated, but also crash Excel if i don't. The spreadsheet has a RTD feed and uses a class module to manage the tables. Could this be "unresolved ranges/links" or something similar?

Sub OPEN_CONTROL_PANEL_USERFORM() ufCONTROL_PANEL.Show End Sub Private Sub UserForm_Initialize() 'code commented out End Sub
Improve this question

1 Answer 1

Reset to default
2

You could try running the free VBA Code Cleaner in case there's an issue with the VBA. It exports all the modules, deletes them from the project and then re-imports them which fixes some subtle issues like this. It's also a great way of exporting code modules for use with source code control.

I've used it a lot and recommend it.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Thanks this sounds very likely. I'll give it a try.
That seems to have sorted out the small illogical bugs. Thanks for the suggestion.
Caveat: As mentioned at the cited link, the VBA Code Cleaner DOES NOT support 64-bit versions of Excel

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.