Execution Error "Range of the object failed" when running macro

Dear,

Please check the file attached.

It contains a VBA Module "M13_ClientOrProspect" which adjusts the text displayed on the cell GENERAL! G7 depending on the value of the cell GENERAL! G1.

The code seems to work but after running I still get an execution error, and I don't understand why.

Please Login or Register  to view this content.

Can someone please help me?

Thanks
Simon

Please Login or Register  to view this content.

That code changes values on the General sheet, which has a Worksheet_Change event that calls that same code. You should probably be disabling events temporarily, either in the ClientOrProspect code or in the Change event, depending on whether the other codes you run from there should or should not trigger other events.