Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA overflow
Shapes doesn't have a delete method. What you can do is
ActiveSheet.Shapes.SelectAll Selection.Delete -- Regards, Tom Ogilvy "Christof" wrote in message ... Chaps, I have a macro which calls a function to delete all shapes on a worksheet. If that sheet holds many shapes (100+), then the code crashes while deleting the shapes: (memory at ... could not be read) I've tried many implementations to delete these shapes (deleteAll, for each, ...) but I always end up in the same situation Can somebody give me the best way to avoid this problem? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is format overflow? | New Users to Excel | |||
Overflow error.. why? | Excel Discussion (Misc queries) | |||
Data overflow to second worksheet | Excel Worksheet Functions | |||
Overflow Error | Excel Discussion (Misc queries) | |||
VBA overflow | Excel Programming |