Excel 2011 Auto-Extending Spreadsheet

[bunnspecial]

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

 

[exegete77]

I used to write XL macros for a few years, but haven't in a while. What have you written to find the last row?

Here is a macro approach to find the last column in a row, but you can adjust to find last row in a column. Then get a count and and go one row below that

Find last Col in Row