Results 1 to 3 of 3

Thread: How to adjust line spacing of a table pasted into Word from Excel

  1. #1
    VBAX Newbie
    Jan 2020

    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:

    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!!

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Jul 2008
    Cross-posted (and solved) at:
    Please read VBA Express' policy on Cross-Posting in Rule 3:
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Thanks for advice. We are using Excel for salesforce reports and sometimes we need to combine different docs including Word with Excel. Adn I was looking for solving the same issue.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts