LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default XL2002 - Select All Objects in an Array...

If you mean what I think you mean, and specifically for a Line, I posted an
example how to do that -

http://tinyurl.com/yuevs2

Regards,
Peter T

"Trevor Williams" wrote in
message ...
Hi Peter

Do you know how to return the Begin x, Begin y, End x, End y values of an
object that already exists on a sheet?

Thanks

Trevor

"Peter T" wrote:

PS
I changed your
.Shapes.AddLine(335.25, 127.5, 623.25, 127.5).

to
..Shapes.AddLine(35.25, 27.5, 123.25, 127.5)

so I could see them !

Peter T







 
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
Cannot select objects Blue Max New Users to Excel 6 March 23rd 09 12:47 PM
Select Objects cursor Learning Excel 2007 Excel Discussion (Misc queries) 2 May 2nd 07 05:09 PM
how can I select multiple drawing objects at once ExcelUser Excel Discussion (Misc queries) 1 February 11th 05 10:42 AM
The Select Objects button Max Power Excel Programming 1 November 30th 04 12:55 PM
Select Multiple Shape Objects Alan Excel Programming 0 November 24th 04 06:25 AM


All times are GMT +1. The time now is 08:57 AM.

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

About Us

"It's about Microsoft Excel"