Q:

Add value to a specific row in a table using VBA

I want to add some value to a specific row in my table without having to reference the cell number
I have this 
Dim LO As ListObject
Set LO = Sheets(1).ListObjects("table1")

LO.ListColumns("USER").DataBodyRange = "John"

However, this would repeat for every row in my table, how do I get it so its just a single row without having to specifically reference a cell if possible

A:

You've narrowed down the relevant cells to the single USER column sans header. Just add your relative row number to DataBodyRange.
Dim LO As ListObject
Set LO = Sheets(1).ListObjects("table1")

'put 'John' in first row of USER
LO.ListColumns("USER").DataBodyRange(1) = "John"

