hi
this is my code:
this is the error:
-2147417848 (80010108)
Method Delete of object Shape failed.
error 440
It did never happen before. I haven't changed the code since yesterday when all worked perfect. This morning I ran this code several times and it worked. Suddenly (without me changing anything since yesterday) it came up with this error. Once at first. A couple of tries later, again. And now it gives this message on every go.
The only thing I found on this subject is that it's broken links in the code, but that is with very different code so it might not be that reason for me.
I'm not really sure if this is some fault of me or another Excel bug... ? :?
this is my code:
Code:
For Each m_control In ActiveSheet.Shapes
If m_control.BottomRightCell.Row = regelnr + 1 Then
m_control.Delete
End If
Next m_control
this is the error:
-2147417848 (80010108)
Method Delete of object Shape failed.
error 440
It did never happen before. I haven't changed the code since yesterday when all worked perfect. This morning I ran this code several times and it worked. Suddenly (without me changing anything since yesterday) it came up with this error. Once at first. A couple of tries later, again. And now it gives this message on every go.
The only thing I found on this subject is that it's broken links in the code, but that is with very different code so it might not be that reason for me.
I'm not really sure if this is some fault of me or another Excel bug... ? :?