+ Reply to Thread
Results 1 to 2 of 2

VBscript to copy paste chart in exact location in other sheet

  1. #1
    Registered User
    Join Date
    07-12-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    2

    Unhappy VBscript to copy paste chart in exact location in other sheet

    Hi All,
    I am writing vbscript to copy paste chart(or) shapes from one sheet to other sheet.

    I want to copy paste the chart/shape in exact location as in the parent sheet.

    Please help me.. stuck in this..

  2. #2
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: VBscript to copy paste chart in exact location in other sheet

    You need to measure the position of the chart on the first sheet, then use these measurements on the second sheet. This code assumes there's one chart on the first sheet, and you've already copied it to the second sheet, where it's also the only chart.

    Please Login or Register  to view this content.
    Jon Peltier
    http://PeltierTech.com/

+ 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