CopyPicture on a Shapes range
xl2007 has trouble with shapes and .select
I'd try:
ActiveSheet.Shapes.Range(Array("Chart 27", "Chart 9")).copypicture
(but I didn't actually try it!)
Kevin Beckham wrote:
I have a graph overlaying another and want to copy them together. The
following code snippet worked in Excel 2003
ActiveSheet.Shapes.Range(Array("Chart 27", "Chart 9")).Select
Selection.CopyPicture
but doesn't work now. Has there been a syntax change or is it no longer
supported?
Kevin Beckham
--
Dave Peterson
|