Positioning of figures
 

Hi!

With the command ActiveSheet.Shapes.AddLine(300#, 300#, 300#, 300#).Select
it is easy to draw figures on the position that u want (upper left corner is
determed by the first two numbers)

I am looking for the invers of this formular: I want to get to know the
position of the upper left corner of a figure on an unknown place on my sheet.

Can anyone help me!?

Positioning of figures
 

ActiveSheet.Shapes(Name).Left and ActiveSheet.Shapes(Name).Top give the
coordinates of the figures.

Thx.

"BZA" schreef:

Hi!

With the command ActiveSheet.Shapes.AddLine(300#, 300#, 300#, 300#).Select
it is easy to draw figures on the position that u want (upper left corner is
determed by the first two numbers)

I am looking for the invers of this formular: I want to get to know the
position of the upper left corner of a figure on an unknown place on my sheet.

Can anyone help me!?