Excel 2011 Auto-Extending Spreadsheet

I have been fighting with this one for a while, and am embarrassed to have to ask the question about this.

I'm trying to write a macro that will automatically add a line after the last line has had data entered.

My problem is that I can only figure out how to make excel add a line before this, and not after. I have a working macro that will do this, but as I said it doesn't work the way I need for it to work.

Any ideas?

Thanks