+ Reply to Thread
Results 1 to 2 of 2

paste excel range into word, maintaining column sizing

  1. #1
    Registered User
    Join Date
    02-13-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    34

    paste excel range into word, maintaining column sizing

    Hi,

    I'm trying to paste a range into word using vba, and am currently using the following code (thanks to the original author):


    Please Login or Register  to view this content.
    The trouble is, when a cell in the required range has too many characters, instead of 'wrapping' the text (like it does in excel), it throws the column sizes.

    What can I change in the above code to make it paste while maintaining the column sizes of the excel spreadsheet? I don't want to keep any gridlines or tables, just the text. The code currently works brilliantly, as long as no cells have too much data in them.

    Thanks in advance.
    Last edited by frostii; 12-24-2016 at 11:08 AM. Reason: wrap code brackets around code

  2. #2
    Registered User
    Join Date
    02-13-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    34

    Re: paste excel range into word, maintaining column sizing

    Never mind guys!
    In my testing I was just typing one long giant word. When I wrote a normal couple of sentences the columns copied across as they should.
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy horizontal range and paste into other sheet if column contains word
    By mangesh.mehendale in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-20-2015, 03:43 AM
  2. Paste Excel Range into Word Doc at certain place
    By v.edwards.jr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2014, 03:24 PM
  3. [SOLVED] Maintaining separate columns of data when pasting from Word to Excel
    By Erik Thomas in forum Excel General
    Replies: 2
    Last Post: 11-09-2012, 07:22 PM
  4. Maintaining Excel formulas in Word
    By jbwithro in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2010, 04:11 PM
  5. Maintaining LINKS from Word to Excel
    By operabuffo in forum Excel General
    Replies: 3
    Last Post: 12-14-2008, 07:02 PM
  6. Maintaining formatting - Excel => Word
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2006, 03:40 AM
  7. Replies: 0
    Last Post: 02-02-2005, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1