Measurements in VBA/Excel

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

Guest

If I write a line of code like Activesheet.rectangles.add 50, 50, 50, 50

What is the system of measurement Excel is using to Draw the rectangle at
Location 50,50 and 50 wide by 50 high?

Inquiring minds want to know...

Is it pixels? Inches? Twips?
 
From the help file...
'---
"Left, Top...Single. The position (in points) of the upper-left corner of the ...
relative to the upper-left corner of the document."

"Width, Height...Single. The width and height of the ..., in points."
---

There are 72 points to the inch.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"jayklmno" <[email protected]>
wrote in message
If I write a line of code like Activesheet.rectangles.add 50, 50, 50, 50
What is the system of measurement Excel is using to Draw the rectangle at
Location 50,50 and 50 wide by 50 high?
Inquiring minds want to know...
Is it pixels? Inches? Twips?
 

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

VBA to remove records 2
Need urgent help 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
VBA retrieve object name in Access form 0
ADO excel VBA to update data in Access 3
Position of selected rows 5
manipulating drawing objects in MS Office 2007 2
Excel export formatting problem for fixed width files 1

Back
Top