PDA

View Full Version : Move chart from one sheet to a specific location on another sheet



Joe Heym
06-21-2006, 07:00 AM
I need a piece of code to move an embedded chart from one sheet to a precise location on another (ie a particular cell). I have tried various things to no avail. Any thoughts?

Thanks

Jacob Hilderbrand
06-21-2006, 07:54 AM
Try something along these lines:


ActiveSheet.ChartObjects(1).Cut
Sheets("Sheet2").Select
Range("B5").Select
ActiveSheet.Paste