Hi k1w1999,

Why are you inserting rows? Is there a reason you can't just move down one row at a time?

Excel 2007 supports 65536 rows in compatability mode, and 1048576 rows in native mode. So, unless you've done a great deal of data entry, I doubt you've used up all the available rows. The most likely explanation is that you already have something on the last available row. What row do you end up on if you press Ctrl-End? Is there anything on that row between whatever column you ended up in and column A?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]