I create new rows to a list in Excel 2007 by this
Dim objNewRow As ListRow
Set objNewRow = Selection.ListObject.ListRows.Add(AlwaysInsert:=True)
When i want to put in some information in my newly inserted row i use the Cells object.
objNewRow.Range.Cells(1,1).Value = "John Doe"
Instead of choosing the columns by numbers i will refer to these with column names from my list. Something like objNewRow.Range.Columns("Name").Value = "John Doe"
Is this possible?
Dim objNewRow As ListRow
Set objNewRow = Selection.ListObject.ListRows.Add(AlwaysInsert:=True)
When i want to put in some information in my newly inserted row i use the Cells object.
objNewRow.Range.Cells(1,1).Value = "John Doe"
Instead of choosing the columns by numbers i will refer to these with column names from my list. Something like objNewRow.Range.Columns("Name").Value = "John Doe"
Is this possible?
