Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 276
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select and Move Cursor Shapes marcopolo New Users to Excel 1 September 4th 08 06:40 AM
Select multiple Shapes CLR Excel Programming 5 June 6th 06 06:13 PM
Compare a selected Range with a Named range and select cells that do not exist PCLIVE Excel Programming 1 October 18th 05 07:09 PM
Select cells based on named Range and a column heading achidsey Excel Programming 3 August 12th 05 03:55 AM
Using Arrays to select Shapes Don Rouse Excel Programming 1 July 18th 04 07:27 AM


All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"