Excel closes when using VBA to write VBA code

I'm trying to write a macro that will update the class module for a select number of sheets in 131 other workbooks. The variable being passed in is the sheets codename. It seems that the module is updated but a fatal error happens when the end with line is run while stepping through the code. Any ideas?

Please Login or Register  to view this content.