| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to select all autoshapes on a sheet
Hi guys,
is there a way to select all the autoshapes on a sheet in vba? At the minute I'm looping an iterator and concatenating onto the word "autoshape", deleting "autoshape 1", "autoshape 2", "autoshape 3"... this is horribly inefficient and besides, stops working when a shape has a name like "oval 5760"! I want to select all the shapes, and delete them all in one go... Many thanks Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to select all autoshapes on a sheet
ActiveSheet.Shapes.SelectAll
schreef in bericht ups.com... Hi guys, is there a way to select all the autoshapes on a sheet in vba? At the minute I'm looping an iterator and concatenating onto the word "autoshape", deleting "autoshape 1", "autoshape 2", "autoshape 3"... this is horribly inefficient and besides, stops working when a shape has a name like "oval 5760"! I want to select all the shapes, and delete them all in one go... Many thanks Chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to select all autoshapes on a sheet
d'oh... that's really simple!
Thanks Moon moon wrote: ActiveSheet.Shapes.SelectAll schreef in bericht ups.com... Hi guys, is there a way to select all the autoshapes on a sheet in vba? At the minute I'm looping an iterator and concatenating onto the word "autoshape", deleting "autoshape 1", "autoshape 2", "autoshape 3"... this is horribly inefficient and besides, stops working when a shape has a name like "oval 5760"! I want to select all the shapes, and delete them all in one go... Many thanks Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot select options in AutoShapes in Excell | Excel Discussion (Misc queries) | |||
| Can I select and Group Autoshapes in Excel 97 ? | New Users to Excel | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| Cant visible autoshapes(Circles, Rect) in sheet and also in print | Excel Discussion (Misc queries) | |||
| Select Sheet then Select Range | Excel Programming | |||
Linear Mode
