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.
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.