Copy One Range of Cells in One Worksheet to Next Available Row in Another Workbook

Hey Guys. I am trying to write a code that copies a specific range of cells from one worksheet (called Game) into another worksheet's (called Games 1-500) next available row. Here is the code I have thus far:

Please Login or Register  to view this content.

I am getting Error 9 "Subscript out of range" -- I have read that this could be from Excel trying to execute a code from a worksheet which does not exist. I have verified that the two sheets named in the code are in the fact correct so I'm not sure why I'm still getting this error. Thanks!

Thanks for the responses. Norie may have been correct, there may have been a space somewhere in code because I copied the above code and it worked. The problem is the macro copies the contents into the wrong cells. I have attached the workbook so you guys can see what I am working with. The first part of the macro is fine, it copies the worksheet "Game" cells H3:O3 (I originally had I3 but fixed that). It pastes into the worksheet called "Games 1-500" but copies to cell C512 (which technically is the next row with nothing in it) but I want it to paste to Range C33:J33 (the next open line) and so on. What do I need to add to my code to tell Excel to do that? Thanks for the help!

Originally Posted by Norie

Just saw your updated post and I think it's column C that needs to be used to find the next empty row.

That's what this code does.

Please Login or Register  to view this content.

This worked perfectly, thank you. Just for my personal benefit: I noticed the "wsGame1500.Cells(Rows.Count, 3) changed from (Rows, Count 1) -- I'm assuming the 1 equals column A (thus 3 equals C). Having said that, I still don't see where Excel reads the code that tells it to place the values under each line of game stats instead of starting at row 512?