Obtain an objects current location
 

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?

Obtain an objects current location
 

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


"Jive"

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?

Obtain an objects current location
 

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
---------------
Jacob Skaria


"Jive" wrote:

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?