Consulting

Results 1 to 3 of 3

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

  1. #1
    VBAX Newbie
    Joined
    Jan 2020
    Posts
    1
    Location

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

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Cross-posted (and solved) at: https://www.msofficeforums.com/word-...sted-into.html
    Please read VBA Express' policy on Cross-Posting in Rule 3: http://www.vbaexpress.com/forum/faq...._new_faq_item3
    Cheers
    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
  •