+ Reply to Thread
Results 1 to 2 of 2

Problem With pasting table as Image

Hybrid View

  1. #1
    Registered User
    Join Date
    09-21-2016
    Location
    Tel Aviv, Israel
    MS-Off Ver
    2016
    Posts
    1

    Red face Problem With pasting table as Image

    hey,
    I'm using this macro in order to copy a table and paste it to powerpoint presentation:
    Sub pic_to_pp()
    '
    ' pic_to_pp Macro
    '
    
    '
        Selection.Copy
        ActiveSheet.Pictures.Paste.Select
        Application.CutCopyMode = False
        Selection.Cut
        ActiveSheet.PasteSpecial Format:="bitmap", Link:=False, DisplayAsIcon _
            :=False
    '    Selection.Cut
     '   ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)", Link:=False,
    '        DisplayAsIcon:=False
        Selection.ShapeRange.Width = 800
        Selection.Cut
    End Sub
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

    and for some reason it creates thicker lines in the middle of the table how can I solve it ?
    Last edited by 6StringJazzer; 09-21-2016 at 12:43 PM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Problem With pasting table as Image

    It may have to do with the way you "cut." Here is a piece of code I use for this purpose:

    sh.Range(ObjName).CopyPicture

    I don't know if there is a like CutPicture.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Copying and pasting a table with formulas within the same worksheet problem
    By feelinglikeanoob in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2016, 01:48 AM
  2. Problem with image File Link in Cell not opening image for preview
    By Orada in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2015, 09:33 AM
  3. Macro to copy table to word as an image (problem)
    By rodroliveira in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 06:58 PM
  4. Replies: 1
    Last Post: 02-19-2014, 11:46 PM
  5. Replies: 0
    Last Post: 12-08-2010, 01:02 PM
  6. Pasting cells as an image
    By aapaan in forum Excel General
    Replies: 3
    Last Post: 04-17-2009, 09:23 PM
  7. problem pasting Word table into Excel
    By md95065 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-26-2007, 01:04 PM

Tags for this Thread

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