Better_Days
05-18-2018, 05:49 AM
I've a sheet that receives data from another program and now and then it fatally crashes, I'm thinking it's due to some data not being present that it's expecting. It's receives betting data and once a non runner is declared I guess price data for it is missing. I'm not sure where it's falling over though as it just freezes and has to be shut down and reopened. I have on error resume next in a few places but still crashes.
Is there any code I can add to the overall sheet that would catch where the sheet is falling over rather than trying to try and pin which code in all the various modules is crashing. It currently fires everything off using a Worksheet_Change event to call routines in various modules at te moment.
Is there any code I can add to the overall sheet that would catch where the sheet is falling over rather than trying to try and pin which code in all the various modules is crashing. It currently fires everything off using a Worksheet_Change event to call routines in various modules at te moment.