I'm trying to add new data within a certain row of a table, however the location it is added into depends on the value of another cell.
Sheets("Sheet1").Select
Range("B12").Select
Selection.ListObject.ListRows.Add (2)
In Sheet2, cell A13 contains the name of the cell I want to add a row on. So A13 contains the value B15 and I want to select and add a row on Sheet1 at Cell B15.
Cell A13 changes based on other values, so I need this cell to referenced for the selection.
Any ideas? (<<Obvious VBA noob)
Bookmarks