Row in table?

EXCELn00b18 · Mar 14th 2018

How to insert row including formula to the end of a table using VBA? I have a formula to generate the next number in my table, but as of right now the only way i can find to add another row is to tab all the way to the end of the table. Is there a way to automatically add a row and insert that formula to the end of the table?

**pike** · Mar 15th 2018

Hello

Code

With Range("Table1")
         .Rows(.Rows.Count + 1).EntireRow.Insert
         .Resize(.Rows.Count + 1, .Columns.Count).Name = .Name.Name
    End With

Row in table?

Participate now!

Share