+ Reply to Thread
Results 1 to 6 of 6

VBA to cut picture then paste in new sheet

  1. #1
    Registered User
    Join Date
    04-30-2017
    Location
    Pretoria, South Africa
    MS-Off Ver
    2013
    Posts
    54

    VBA to cut picture then paste in new sheet

    Its probably simple, but Im merely trying to cut this picture from one sheet to the final sheet

    Please Login or Register  to view this content.
    I used the recorder to get the image name, should i be defining this picture or something?

    I am not sure how to make this picture an object in order to cut then paste.

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: VBA to cut picture then paste in new sheet

    hi
    try

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-30-2017
    Location
    Pretoria, South Africa
    MS-Off Ver
    2013
    Posts
    54

    Re: VBA to cut picture then paste in new sheet

    Quote Originally Posted by NickyC View Post
    hi
    try

    Please Login or Register  to view this content.
    This worked!

    But i tried to tailor it so that it pastes into a certain range

    Please Login or Register  to view this content.
    doesnt seem to work?

    Or should i be trying another way to move this to that location?

  4. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: VBA to cut picture then paste in new sheet

    Try
    Please Login or Register  to view this content.
    Last edited by Sintek; 05-16-2017 at 06:44 AM. Reason: Edited....Removed point
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  5. #5
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: VBA to cut picture then paste in new sheet

    ok try this
    Please Login or Register  to view this content.

  6. #6
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: VBA to cut picture then paste in new sheet

    @ NickyC
    Please Login or Register  to view this content.

+ 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. Click on picture and run macro to replace existing picture with selected picture file
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 12:02 AM
  4. Replies: 2
    Last Post: 10-29-2013, 01:15 PM
  5. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  6. Paste picture
    By swoop99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2011, 04:20 PM
  7. Can't paste picture while Protect Sheet is on...
    By groundhog1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2006, 04:10 PM

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