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..
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..
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/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks