Automation Error: Catastrophic failure

Hello everyone, I'm new to VBA and I'm getting an error that I can't find any good information on. The error happens whenever I open a workbook that I made. It says Automation Error: Catastrophic failure. When I press OK it brings me to the debugger and highlights the first line of a function I wrote. I can usually fix it by pressing reset, but sometimes that doesn't work and I need to reset the project by just putting in a line of code and then deleting it. Has anyone else had this issue before? If so, how do you stop it from happening?

I think you'll need to at least post some example code and explain what your macro is doing in order to get a diagnosis.

I don't think I can upload the workbook as it contains confidential client information, but I can show a screenshot of the error. Would that help?

I have had issues like this (if fact not even a week ago). Every time that I have had this issue it had to do with referencing something that was no longer there. THIS IS AN EXAMPLE: Like a public worksheet variable when I have set the workbook = nothing. It happens that the worksheet variable shows no properties but is also not nothing. Thus checking if the worksheet is nothing doesn't work and then you get an automation error.

Things that I have noticed. The program works fine, but if running it several times I would get an automation error (unless I have properly ending the program with "End" or setting all public variables to nothing). Closing Excel and trying again, and all would be good. It seems random but it is not.

My 2cents in avoiding automation errors (well one specific to this example):

If using .Parent (make sure that goes somewhere) and write procedures that take arguments over having public variables whenever feasible.

V/R,

Rich