Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Paste Special Excel to Word - Size

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In attempting to Paste Special an MS Excel Worksheet to Word, the pasted information is incomplete. That is, only 35 out of 45 rows are pasted.
    If I do Paste only, without linking, it pastes correctly.
    Any ideas why this is happening and how it might be corrected?
    Thanks,
    Fred

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi FDR_Texas,

    I assume you are doing a Paste Special as a "Microsoft Excel Worksheet Object", in which case the cell range you copied will become an embedded worksheet object (either linked or not). With such objects, even if you don't see the entire range you copied, not only is it there, but the entire workbook is actually there, embedded in the Word document. When you double-click on this object in Word it will open it for display/editing in Excel. If you want to change the range of cells that is displayed at this time, simply use the drag points on the edges of this box to resize the area to include the rows and columns you want to display in Word.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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