+ Reply to Thread
Results 1 to 2 of 2

Copy specific range selection to msword but why it copies columns not in range?

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    42

    Question Copy specific range selection to msword but why it copies columns not in range?

    Good Day!

    I just want a little help on my problem. I have a range as below that I want to copy to msword. Only the selected range of columns B, C, J, K. But when it reaches to msword it copies also D, E, F, G, H, I:

    Please Login or Register  to view this content.
    How to make it to only copy the selected range which is column B, C, J, K?

    Thank you for helping.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Copy specific range selection to msword but why it copies columns not in range?

    I do not know why this happens but it does. The Union successfully pastes into Excel but not into Word.
    Here is an easy workaround:
    - paste "Union" table into an unused area in Excel first
    - copy that table into Word
    - delete "Union" table in Excel


    Please Login or Register  to view this content.

+ 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 several columns into a specific range (new workbook)
    By Barrigudo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2016, 05:19 AM
  2. [SOLVED] Copy Specific Columns from a Filtered Range
    By Saarang84 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 05-16-2015, 12:38 AM
  3. Replies: 0
    Last Post: 12-10-2014, 11:30 AM
  4. Copy a specific row and a range of columns to next available row on another worksheet
    By monkey1184 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2013, 05:02 PM
  5. copy specific range of rows and columns according to a cell value
    By archangel9999 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2013, 03:41 PM
  6. Copy and paste specific range to date specific range in alternate sheet
    By alanalmarza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 08:29 AM
  7. Selecting range using .range. But can you do same selection using .columns
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-01-2011, 01:31 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