Obtain an objects current location

  • Thread starter Thread starter Jive
  • Start date Start date
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?
 
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?
 
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
 
Back
Top