Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to select ALL named shapes in range
i have named by code an array of shapes on a worksheet.
eg. o1-o80 and og1-og80 and l1-l80 and ig1-ig80 and i1-i80 and p1-p80 and h1-h80 and t1-t80 and e1-e80 and d1-d80 I want to be able to select ALL of these items(Named shapes) so i can move them on the worksheet, but how can i select them all with code? Regards Corey |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to select ALL named shapes in range
Never mind used:
ActiveSheet.DrawingObjects.Select and de-selected the objects not required. -- Regards Corey "Corey" wrote in message ... i have named by code an array of shapes on a worksheet. eg. o1-o80 and og1-og80 and l1-l80 and ig1-ig80 and i1-i80 and p1-p80 and h1-h80 and t1-t80 and e1-e80 and d1-d80 I want to be able to select ALL of these items(Named shapes) so i can move them on the worksheet, but how can i select them all with code? Regards Corey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select and Move Cursor Shapes | New Users to Excel | |||
Select multiple Shapes | Excel Programming | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
Select cells based on named Range and a column heading | Excel Programming | |||
Using Arrays to select Shapes | Excel Programming |