Measure height/width in millimeters

T

TimHollis

New Member
Joined
Jun 10, 2003
Messages
8
It really can't be THAT difficult to get Excel to measure cells height and width in millimeters, can it?

A link would do!

Thanks,
Tim


PS I'm totally clueless when it comes to macros - but if it needs to be done via a macro then I'm sure I could work it out, with a little help.


:oops:
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sort by date Sort by votes
I think:

Code: 
Sub Test()
    MsgBox "Row height is " & ActiveCell.EntireRow.Height / 72 * 25.4 & " mm"
    MsgBox "Column width is " & ActiveCell.EntireColumn.Width / 72 * 25.4 & " mm"
End Sub

Height and width are in points (1/72nd of an inch).
 
Upvote 0
Andrew Poulsom said:
Height and width are in points (1/72nd of an inch).
Click to expand...
Height: Yes,
but (according to Excel help): "Column width is measured by
the width of 1 character in the profile "Normal". In case of proportional characters, the width of the character 0 is used."

Albert 1
 
Upvote 0
Albert 1 said:
Andrew Poulsom said:
Height and width are in points (1/72nd of an inch).
Click to expand...
Height: Yes,
but (according to Excel help): "Column width is measured by
the width of 1 character in the profile "Normal". In case of proportional characters, the width of the character 0 is used."

Albert 1
Click to expand...

That's the ColumnWidth property. The Width property returns points. To demonstrate:

Code: 
Sub Test()
    With ActiveCell.EntireColumn
        .ColumnWidth = 8
        MsgBox "Column width is " & .ColumnWidth & " width is " & .Width
    End With
End Sub
 
Upvote 0
Andrew Poulsom said:
The Width property returns points.
Click to expand...
Yes, the width-property returns points, that's also what I wanted to say.
But I thought, you couldn't multiply the points by 1/72 to become the columnwidth in mm's. Probably I'm wrong...
 
Upvote 0
cell width and height measurements

Make a column width = 13 then run ActiveCell.RowHeight = ActiveCell.Width
this makes what looks like a perfect square and is confirmed as being 72/72 width and height, but on printing instead of being 1" square it is slightly more. In fact 7 of these cells = 17 cms equiv to 2.428571429
per square and should be 2.54 ??? thoughts
 
Upvote 0
You must log in or register to reply here.

Similar threads

melodramatic
  • Question
Vba - insert photo with varying sizes
Replies
1
Views
292
Micron
M
C
  • Question
All I want is just a check mark option in a cell..... that look normal
Replies
3
Views
723
Caper1144
C
C
  • Question
COUNTIFS for Filtered Data, to Measure Date Ranges
Replies
2
Views
1K
Fluff
Fluff
M
  • Solved
VBA to find most recent Invoice Date for each Customer
2
Replies
10
Views
641
kevin9999
K
spacecaptainsuperguy
  • Question
Advice for linked files on network drive
Replies
0
Views
350
spacecaptainsuperguy
spacecaptainsuperguy

Forum statistics

Threads
1,215,420
Messages
6,124,803
Members
449,190
Latest member
cindykay

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top