Macro causing excel 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)?

If you're using recorded code then you're pushing it uphill. You will be very lucky to have that code do anything other than what it was recorded for.
Have you got an example workbook?

But all I want it to do is what I'm recording it to do. I'm at work now, I will work on uploading a copy with just the tables I'm trying to work with. Does the cell selection before I run it need to match the cell selection when the macro recording began?

Yes the conditions have to be exactly the same, or you'll get an error

So if the table is, say B2:E10, and I start recording the macro with cell A1 selected, I need to select A1 before running the macro? Does the fact that it involves tables change the procedure at all?

The tables shouldn't make any difference provided they're in the same place & the same size, the macro does the same thing every time.
It's impossible to say exactly what's happening without an example workbook

I actually re-posted the question in the "macro" specific section. I didn't realize there was a space for these issues outside of this formula section. I attached a file there. Here is the link:

http://www.excelforum.com/excel-prog...-to-crash.html

Cross posting/Double posting is a big no no, especially without the links so we're aware of it

I'll have a look a bit later on today

Thanks. I'm certainly not trying to ruffle any feathers. I've misplaced posts before by mistake. I realized I misplaced this one after the fact but couldn't find where to delete this thread.

Hi Bradley, Check the other thread