Excel 2011 Auto-Extending Spreadsheet

Discussion in 'Mac Apps and Mac App Store' started by bunnspecial, Aug 24, 2015.

  1. bunnspecial macrumors 603

    bunnspecial

    Joined:
    May 3, 2014
    Location:
    Kentucky
    #1
    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
     
  2. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #2
    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
     

Share This Page