Clear Word Table Row from Excel VBA

[natefarm]

I'm trying to clear the data out of a Word table row without deleting the row and have already wasted half a day on it, including extensive internet search, but nothing seems to work. I haven't found any code to delete the contents of a row with a single command. I'm trying to select the row and then delete the data, but the code I'm using gets a run-time error - Object doesn't support this property or method. Here's that code:

wdDoc.Tables(TblID).rows(tblrow).select
wdDoc.Tables(TblID).selection.delete

Also tried with same error result:

wdDoc.selection.delete

It selects the row, but apparently the Delete method doesn't work in that context.

I tried recording a macro in Word to see how it did it, but you can't select a table row while a macro is recording. Help, please!

[Sbarro79]

Did you try:

wdDoc.Tables(TblID).Rows(tblrow).Select
Selection.Delete

I not familiar with Word VBA, but it worked for me.

[Leith Ross]

Hello natefarm,

In VBA it is rare that you need to select an object before performing an action on it. The code below will Clear the cell contents of the specified Table row and not delete the row from the table.

            For Each c In wdDoc.Tables(TblID).Rows(tblrow).Cells
                c.Range.Delete 1, Len(c.Range.Text)
            Next c