Positioning of figures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!?
 
ActiveSheet.Shapes(Name).Left and ActiveSheet.Shapes(Name).Top give the
coordinates of the figures.

Thx.

"BZA" schreef:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Positioning Web Control using css in VS 2008 1
HOW TO SPLIT FIGURES BY MACRO 2
Position of CellCursor on Screen (absolute position) 1
How to got the position of a cell/range in pixels (from the left-top corner) ? 1
AMENDMENT IN MACRO 2
PLEASE HELP ! "SPLIT AMOUNT BY MACRO" 1
Print Area to include text box 10
How can I Center a Dialog Box each time a user opens it? 1

Back
Top