Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a macro that draws objects on the worksheet based on data contained in
the cells. In Excel 2003, with a worksheet of 500 lines of data, this macro ran in about 15 seconds. In 2007, it takes upwards of 15 minutes. As the macro works down the sheet, the process of drawing my triangles and diamonds gets slower and slower. It seems like Excel loses processing speed as more and more objects are drawn on the page. Is there some way to improve this process? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Group drawing objects in VBA | Excel Discussion (Misc queries) | |||
Cutting Drawing Objects | Excel Discussion (Misc queries) | |||
HOW DO I KEEP DRAWING OBJECTS ANCHORED? | Excel Discussion (Misc queries) | |||
how can I select multiple drawing objects at once | Excel Discussion (Misc queries) | |||
How do I put drawing objects behind text/cells in a spreadsheet? | Excel Discussion (Misc queries) |