+ Reply to Thread
Results 1 to 5 of 5

Code to paste shape - does not work

  1. #1
    Registered User
    Join Date
    05-04-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    8

    Code to paste shape - does not work

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 05-04-2009 at 03:59 PM. Reason: Added Code Tags

  2. #2
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Re: Code to paste shape - does not work

    Hi Thole,

    Try using 'Activesheet.Paste' instead of 'Selection.Paste'

    Regards,
    Karan

  3. #3
    Registered User
    Join Date
    05-04-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Code to paste shape - does not work

    Thank you, but it didn't do the trick.
    The macro runs, but I do not get any results.
    Did I not declare something correctly?

  4. #4
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Re: Code to paste shape - does not work

    Its okay if you don't declare everything unless you write 'Option Explicit' on top of the module.

    I tried running the code at my end and it seems to function properly. Can you post the error message which you are getting?

    --Karan--

  5. #5
    Registered User
    Join Date
    05-04-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Code to paste shape - does not work

    There is no error code.
    The code runs, but I get no results.
    I will try it on its own, and not part of my bigger project, to see what gives.
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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