+ Reply to Thread
Results 1 to 5 of 5

Copy range from a sheet to another sheet, as picture

  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    Paris
    MS-Off Ver
    Excel 2010
    Posts
    17

    Question Copy range from a sheet to another sheet, as picture

    Hello,

    In sheet A I have a range with merged cells.
    So, I think the best solution to copy this range in sheet B is to "paste as picture" (the sheet B, where is the vba core, is only build to print).
    But I really don't know how to paste as picture in my case.

    Please Login or Register  to view this content.
    Could you help me please ?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Copy range from a sheet to another sheet, as picture

    Here is a generic example of copy as a picture and paste

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-12-2012
    Location
    Paris
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Copy range from a sheet to another sheet, as picture

    Hello,
    Thanks for you help.

    I try this code but it doesn't work.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-12-2012
    Location
    Paris
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Copy range from a sheet to another sheet, as picture

    I still have not managed to code this. I'm turning around
    Could you help me please ?

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Copy range from a sheet to another sheet, as picture

    Works for me. I can offer no further assistance. Perhaps if you upload a sample workbook someone here may be able to determine the issue. Also, does not work is not very helpful to anyone trying to solve your issue. What happens? Error message? What results do you get?

+ 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. vba to copy a picture from a hidden sheet and paste in visible sheet?
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-30-2015, 10:21 AM
  2. Replies: 1
    Last Post: 10-02-2014, 09:24 PM
  3. [SOLVED] Does sheet need to be visible to copy picture from it?
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-28-2014, 11:33 PM
  4. [SOLVED] Copy Template Sheet with Picture to all new sheets
    By guitarsweety in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2014, 11:34 AM
  5. Copy a picture that I click to another sheet.
    By cptcrash in forum Excel General
    Replies: 3
    Last Post: 08-11-2013, 07:09 AM
  6. [SOLVED] VBA to copy picture on click from another sheet not functioning
    By jake.masters in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2012, 10:41 AM
  7. Problem when copy pasting a picture from sheet to sheet
    By leugu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2011, 04:07 AM

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