I have a range of cells that include a chart that I am copying and pasting (Many Times) from 1 worksheet to another. Before pasting, the code ends down and offsets to get to the desired range on the worksheet. The problem is... How do I reference the last chart pasted? I need to reference the chart,copy picture,paste picture to get rid of the links in the chart, and the reference to the chart changes everytime... chart 1, chart 2 ect.
Thanks
Wrecker
Thanks
Wrecker