View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 276
Default 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