MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Setting the paste location of a chart

Posted by Arrie on July 30, 2001 1:14 PM

I am creating a chart through the use of a macro. Everytime the chart is created, it pastes itself in the middle of the page. I want to paste multiple charts on the same page, but cannot figure out how to set the paste location variables.

Posted by Mark W. on July 30, 2001 3:12 PM

Did you try selecting a cell where you want the
top-left corner of the chart to be?