Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

bunnspecial

macrumors G3
Original poster
May 3, 2014
8,390
6,565
Kentucky
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
 
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
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.