cell width in vba - measurement unit

[lezawang]

Hi
I want to change a cell width in vba. So I wrote the code below. I also went to option-->advance-->display-->ruler and change the unit to centimeters. I selected cell A1 and then went to home-->format-->cell width and it gave me 8.35.

My questions:
1) why excel did not show measurement unit when I went to home-->format-->cell width
2) when I change the width in my vba code to 20, what does 20 means here? cm or what? how can I make sure it is change to 20 cm in vba? Thank you

Sub col()
       ThisWorkbook.ActiveSheet.Columns(1).ColumnWidth = 20
End Sub

fyi chaning cell width/measurement unit article below

https://support.office.com/en-us/ar...w-height-72f5e3cc-994d-43e8-ae58-9774a0905f46

 

[Michael M]

The default unit for columns is points.
As it's the default there is no need to identify it.
There are 28.3464567 Points in a centimetre.
so 20cm would be 566.929134 Points

Sub col()
       ThisWorkbook.ActiveSheet.Columns(1).ColumnWidth = 566.929134
End Sub