Trouble Adding VBA Code to Module; Bug in Excel/VBE?
Hi,
I was referring the procedure you are inserting the code into.
Application.run is not applicable if the procedure is called by event.
I would suggest you to create a dummy sub which you will call with
application.run just when finished with generating the code. It should
force excel to recompile the code.
I don't know the reason why excel sometimes is not able to recompile
code if call is used, sorry.
Regards,
Ivan
|