The first time it happened was yesterday.
I had a list of 20,000 thousand calls. Rather than delete the ones I didn't
want, I thought I'd run a macro to count the ones I did to save on formulas
and calculating time.
I had the macro run though i = 5 to 20,010, and if cells(i,5) was less than
30 then I'd set rang = i & ":" & i and select rang and delete it.
When I ran the macro it looped to about row 300, deleting a few lines along
the way. Then that error showed up, since I could find nothing wrong with the
code (hell, it had already cycled 300 times) I just hit continue and it
continued to about row 450 and the same again. After hitting continue each
time it happened to row 1000 I got bored and did it manually with a sort and
such.
Second time it happened I had excel crash on me, then whenever I tried to
reopen it I got the error straight away, when it was trying to add a menu
with a command to a userform. This stopped erroring when I logged out and
back into the computer.
As far as I can tell, this error never pops up on anything I've done, but
something the system is doing, or Excel, or something...
