Reply to thread

Message: [QUOTE="Peter T, post: 6173448"] Hi Anthony, I don't have xl2007 (see below) so can't answer your question how to report a bug, but I'll speculate about this this line of code you posted - Selection.Interior.Pattern = xlSolid At the Shapes level to set a pattern first need to set the FillFormat type (though can use .Patterned followed by a pattern constant without an =), eg ActiveSheet.Shapes(1).Fill.Solid so with the above wouldn't then need to apply xlSolid, though note as a shape pattern format - xlSolid = msoPattern5Percent = 1 I wonder if this is just a special case your drawingobjects method fails in xl2007. Re your comment concerning performance with Shapes or Drawing Object - With a large number of shapes like you I find Shapes slow doing certain things, but I find Drawingobjects very considerably faster. I posted some comments a couple of weeks ago in thread subject: "DrawingObjects". As I mentioned I don't have xl2007 but hope(?) most methods with DrawingObjects will continue to be supported, though disappointed to see this in your code - I tried to obtain an early xl2007 beta last October but for some reason MS 'aggressively refused to supply it. Regards, Peter T [/QUOTE]