Problem with copy and paste code

[chriswrcg]

I use this code to copy and past to the next available line moving downward. When I first wrote it I did not have anything under where this was posting but now I have had to add a section to my document.
The problem is that when this code paste the copied material it does not "push" down the new area but rather is "eating" it up. How can I modify this code so that it "pushes" down the other section?

Please Login or Register  to view this content.

[davesexcel]

The only thing that comes to my mind is that you have a blank cell in column A, if that is the case, you could change the row count to a more static row.
For example if column B always has something in it then.

Please Login or Register  to view this content.

[jolivanes]

There is a period missing in .Rows.Count