Macro causing excel 2010 to crash

I am building a file to track various things at the golf course. One of which being handicap. Part of the file has two tables. One with 20 rows for the score listing and another on another tab for archived scores. I am running a macro to insert a new table row into the first table, copy the then 21st entry into the archive table, then delete the 21st row of the first table. When I tested it first, it ran with no issues. When I plugged more data in and tried it again, it crashed. I can't figure out why or how to fix it. Does the starting cell when recording the macro matter (if the table begins in B2, would it matter if the selected cell is A1 or B2 when beginning the recording of the macro)? Or would the selected cell matter when using the keyboard shortcut to run the macro (in B2 - the first cell of the table, or any other cell in the workbook)?

You're probably going to have to post the workbook or an example that replicates the problem so someone can play with the code.

Fair enough. I will upload something when I get home from work. Thanks

Alright, here we go. I've attached a file. I have recorded the macro I want. I tested it once and it crashed.

These are obviously steps I can just do manually, but I'd prefer to run the macro with one keyboard shortcut if I can help it.

Hi Bradley
I didn't bother trying to figure out what was happening with the recorded code, I made up some code to do what you described in your first post.
Let me know how it goes
Cheers

Please Login or Register  to view this content.

Thanks. I will give it a run and see. Is that code in the macro now? And where is the starting point I need to be when I want to run it?