Engineer Joe
Well-known Member
- Joined
- Jun 10, 2005
- Messages
- 549
Code:
Sub CopyInsertRow()
On Error Resume Next
Selection.EntireRow.Copy
Selection.EntireRow.Insert
End Sub
I've run the above script a ton. I've got it shortcut key'd. Sometimes I run it 5 or 6 in a row. Almost daily, directly after running it, Excel will crash and I'll get that "Excel has stopped working" message. I noticed it's basically only after this macro that Excel will crash, but it's only like 1 out of every 100 times. Anyone know what could be causing that or how to fix it?