'Formatting a table pasted from Excel to Word

Hi all from a rookie and sporadic vba user. I have successfully copied a set of tables from Excel into Word and, with the first routine below, formatted each one. In order to accommodate a larger font, I then need to change the row height of the first row and also to change the paragraph line spacing but the second piece of code fails to do this. I'm sure the solution is simple ......

For t = 1 To 6
    With appWD.Selection.Tables(t)
    .TopPadding = 0
    .BottomPadding = 0
    .LeftPadding = 0.11
    .RightPadding = 0
    .Spacing = 0
    .AllowPageBreaks = True
    .AllowAutoFit = True
    .Rows.SetHeight RowHeight:=12, HeightRule:=2
    End With
Next t

For t = 1 To 6
    With appWD.Selection.Tables(t).Rows(1)
    .SetHeight RowHeight:=18
    .ParagraphFormat.LineSpacing = 15
    End With
Next t

••••ˇˇˇˇ

I'm running Excel/Word 2016 on a mac.

Thanks.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source