Results 1 to 3 of 3

Trouble pasting a picture of my table onto a new tab

Threaded View

mhryniewicz Trouble pasting a picture of... 03-10-2020, 04:20 PM
scottiex Re: Trouble pasting a picture... 03-10-2020, 10:18 PM
Pepe Le Mokko Re: Trouble pasting a picture... 03-11-2020, 03:49 AM
  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.

    Range("A1:G202").Select
        Selection.SpecialCells(xlCellTypeVisible).Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Scorecard Pic").Select
        Range("A1").Select
        ActiveSheet.Pictures.Paste.Select
        ActiveSheet.Shapes.Range(Array("Picture 8")).Select
    Last edited by Pepe Le Mokko; 03-11-2020 at 03:49 AM. Reason: Code tags

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