ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to select ALL named shapes in range (https://www.excelbanter.com/excel-programming/371392-how-select-all-named-shapes-range.html)

Corey

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



Corey

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





All times are GMT +1. The time now is 02:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com