View Single Post
 
Old 01-03-2020, 07:21 AM
rkeck05 rkeck05 is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2020
Posts: 1
rkeck05 is on a distinguished road
Question How to adjust line spacing of a table pasted into Word from Excel

Hi all, I was hoping someone could help me with formatting of a table that I just pasted into a word doc from excel, specifically the line spacing given excel cells don't offer spacing the text at 1.5x or 2x like word does. Without posting all the code, I have this simple section which selects the table in Excel and pastes it into Word based on the bookmark set. I then would like to somehow select that table after said pasting and change the line spacing of the text:

wsRepCom.Activate
wsRepCom.Range("Table3").Copy
wd.Bookmarks("Table3").Range.PasteExcelTable False, False, True

The above successfully pastes the table, just not sure how to then adjust the line spacing. Any help is much appreciated!!
Reply With Quote