H

First of all thanks for all the help

What I'm attempting to do is gather worksheets from various workbooks into one final workbook. What Jon suggested would work fine if the data is on the same worksheet as the chart or if I want it to be at the end. The problem is that I don't want it to be because in the final workbook each worksheet ends up being a page of a large report. This is a final stage of my Excel reporting engine project

By the sounds of it looks like chart.CopyPicture approach and than paste and reposition in the new workbook is the only way

Thank

Shawn