I know the title sounds a little crazy but I am looking into methods of creating a data log for a very complex macro which includes a web scraper module. I am trying my best to reproduce the error 424 it generated but it is taking me hours and yielded no results still. So, I thought of a code that could somehow imitate the Windows error data log to get to the root of the problem as the macro is forcing a terminate or session end instead of offering the debug option when the 424 error message popped up.

Basically, I am looking into ways to create a log that would tell what was calculated and what was posted over to whichever cell or range or variable. Is this possible?

Thanks a big bunch in advance.


Leon