PDA

View Full Version : Fusing chart and shapes before copying



Frimousse
10-20-2009, 01:07 PM
Hi,

I am trying to copy a charts with shapes drawns on it. In previous version of Excel that was easy but I am having problems with Excel 2007. Basically a chart is generated. Then I draw a few lines on it with the mouse. I then want to be able to copy this altogether as one picture. In Excel 2007 I am not even allowed to shift and select all of them to group them. Is this an issue because I am trying to group a chart with a shape. I tried that code

ActiveSheet.Shapes.SelectAll
Selection.ShapeRange.Group

But it doesn't do a thing. Everything else in my project works to expectation (I'm sure it can be nicer code but that'll do until I get better)

Thanks for any help with this.

Bob Phillips
10-20-2009, 02:09 PM
That code works fine for me.