Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Aha! Managed to solve that one!
When looping through the shapes, it is possible to select multipl items by using; .Select False instead of just; .Select which has the same effect as holding down the Ctrl button whil selecting multiple shapes. e.g. For Each shp In ActiveSheet.Shapes If Left(shp.Name, 1) = "x" Then shp.Select False Next shp Selection.ShapeRange.Group.Select Boici -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
duplicate an array and filter the list based on a grouping | Excel Worksheet Functions | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
Shapes Range Array | Excel Discussion (Misc queries) | |||
Grouping Shapes | Excel Programming | |||
Help -- Loop or Array? How to identify? | Excel Programming |