Adding syntax to clear table column

[duteberta]

What syntax do I add to CLEAR CONTENTS in column "x" prior to adding new row in the VBA below?

'ADD RECORD

Sub AddRecordToTable()
    
    Dim ws As Worksheet
    Dim newRow As ListRow
    
    Set ws = ActiveSheet

    With ws.ListObjects("tbl_SD")
    
    'NEED TO CLEAR CONTENTS  IN COLUMN"x" HERE
    
        Set newRow = .ListRows.Add(1)
        newRow.Range(.ListColumns("ID").Index) = GUID
        newRow.Range(.ListColumns("St").Index) = "IN"
        newRow.Range(.ListColumns("x").Index) = "1"
        

    End With

End Sub

 

[Cubist]

Try on a copy.

.ListColumns("x").DataBodyRange.ClearContents

 

[duteberta]

Bingo- perfect - thanks