Fusing chart and shapes before copying

[Frimousse]

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

[VBA]ActiveSheet.Shapes.SelectAll
Selection.ShapeRange.Group[/VBA]

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]

That code works fine for me.