You can get the number of shapes using
.shapes.count
or
.drawingobjects.count

To delete all drawing objects use
sheetname.drawingobjects.delete

or loop through and just delete specific ones (in case you have buttons etc
you wish to keep).

Tim

--
Tim Williams
Palo Alto, CA


"Brian Matlack"
wrote in message
news:Brian.Matlack.21qm2m_1137431403.3037@excelfor um-nospam.com...

Hi!
Is there a way to know how many drawn objects there are in a
spreadsheet?
Can I select multiple drawn objects and delete them in VBA?
Thanks!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=501711