+ Reply to Thread
Results 1 to 2 of 2

Paste Special to Word

  1. #1
    Registered User
    Join Date
    12-15-2015
    Location
    ND
    MS-Off Ver
    2013
    Posts
    1

    Paste Special to Word

    I use Excel and Word a lot. I find the paste special function very useful to take a cell from Excel and have it pasted into Word. That way I can change the numbers once in Excel and when I open the Word document it asks me if I want to update the linked cells. However, if I insert a row or a column on the spreadsheet the links to Word do not also change and I end up having to re-do the paste special with the new cell.

    Is there any way to insert a column or row in Excel and have the linked cells in Word to change/follow to the new cell so I don't have to redo the paste special?

    Thank you!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,844

    Re: Paste Special to Word

    Have you tried using named ranges for these? I think that, if they are done correctly, a named range will allow you to paste the link into word and have word see the link to a named range. The value Excel provides to Word will depend on how the named range is defined in Excel. As long as the process of adding/deleting rows allows the named range definition to "follow" the cell, the link to word should follow as well.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Macro to paste special from excel to word template
    By shoal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2014, 11:13 AM
  2. Paste Special from Word document to Outlook with VBA
    By REVS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2013, 11:45 AM
  3. Word slowing down using >paste special< with no links
    By Roberthorse in forum Excel General
    Replies: 0
    Last Post: 10-22-2012, 01:36 PM
  4. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  5. Macros to Copy Paste Special from Excel to Word
    By Aproveche in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2010, 09:21 AM
  6. Paste Special from Excel into Word
    By Byman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2010, 03:05 PM
  7. paste special from excel to word
    By johndough185 in forum Excel General
    Replies: 3
    Last Post: 09-19-2007, 04:09 AM
  8. macro to copy selection and paste special as picture in word
    By rabbi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2005, 09:29 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