Obtain an objects current location

J

Jive

Hi

I would like to be able to obtain an objects current location so that it can
be automatically moved based on its current position.

Can you get an objects current X and Y location in points? If so what is the
command?
 
J

Jim Cone

A Shape, Chart and OLEobject have a TopLeftCell property.
--
Jim Cone
Portland, Oregon USA


"Jive"
<[email protected]>
wrote in message
Hi
I would like to be able to obtain an objects current location so that it can
be automatically moved based on its current position.
Can you get an objects current X and Y location in points? If so what is the
command?
 
J

Jacob Skaria

Activesheet.drawingobjects("Rectangle 1").Top
Activesheet.drawingobjects("Rectangle 1").Left

or use the index number as
Activesheet.drawingobjects(1).Top

If this post helps click Yes
 
Top