I run a particular VB macro every quarter to update a set of spreadsheets. The macro inserts and deletes a couple of columns, does some range copying and pasting, and updates some equations.
It worked fine on many spreadsheets for a year or more, but now I'm getting script time-out errors. The only real difference is that my spreadsheets are somewhat larger (about 50 rows and 20 columns).
The errors do not always occur at the same line in the code. In fact, every once in a while the script executes without a problem.
What would cause a timeout problem?
Thanks