+ Reply to Thread
Results 1 to 3 of 3

Trouble pasting a picture of my table onto a new tab

  1. #1
    Registered User
    Join Date
    03-10-2020
    Location
    Hartford, CT
    MS-Off Ver
    365
    Posts
    1

    Trouble pasting a picture of my table onto a new tab

    I'm trying to write a macro to copy the visible cells in a table and paste them as a picture onto another tab. It keeps getting bogged down on the 6th line and I can't figure out why.

    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 03-11-2020 at 03:49 AM. Reason: Code tags

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    1,231

    Re: Trouble pasting a picture of my table onto a new tab

    is Scorecard Pic a chart sheet instead of an excel sheet?

    if so try just removing
    Please Login or Register  to view this content.
    Last edited by scottiex; 03-11-2020 at 10:21 PM.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,102

    Re: Trouble pasting a picture of my table onto a new tab

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ 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 Excel table range to an existing PPT slide, pasting as TABLE, not as PICTURE
    By gurnblanston27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2016, 04:44 PM
  2. Trouble when pasting values into table (~20MG file)
    By Excel4157 in forum Excel General
    Replies: 4
    Last Post: 01-21-2016, 04:24 PM
  3. Trouble Pasting
    By 74256274 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2012, 03:52 AM
  4. I'm having trouble pasting data into specific cells in a table
    By phanjoe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2012, 11:36 PM
  5. Trouble Pasting
    By Winchester in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2011, 12:22 PM
  6. Excel 2007 : Dynamic Picture printing trouble
    By VisionS in forum Excel General
    Replies: 0
    Last Post: 04-15-2010, 06:13 AM
  7. Pasting a Table as a picture
    By The-Kid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2006, 04:02 AM

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