Shapes slow down Macro in Excel 2007

  • Thread starter Thread starter David S.
  • Start date Start date
D

David S.

(Excel 2007)
I am currently running a macro (VBA) that draw lines (similar to a line
chart) on a worksheet. The more lines that the Macro draws the slower the
process gets. In Excel 2003 the whole process took about 60 seconds and now
in 2007 it is takes up to 3 hours. I had the same issue with 2003 but I got
around it by grouping the lines together every so often (basically like
starting over with one object) However in 2007, that trick does not work.
Any ideas on how to flatten the objects out into one object and not be able
to ungroup it?
 
One way to speed up a VBA procedure that uses shapes is to avoid selecting
the shapes. This is especially true in Excel 2007. Also, turn off screen
updating while creating the shapes, so Excel doesn't feel the need to redraw
each shape a thousand times.

- Jon
 
Back
Top