View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leo Leo is offline
external usenet poster
 
Posts: 5
Default Problem with Application.Width

I have a troubles to set up width of application's window.
Due to some reasons I want my application's window cover 10
columns exactly(e.g. user see only 10 columns)
If I handy move application's window so it cover 10 columns
and check application's width by this code:

MsgBox Application.Width

I get number 492 ( I read in help that it is in POINT - about 1/72 inch)

If I run next code:

Sub fghfs()
For i = 1 To 10
a = a + ActiveSheet.Columns(i).ColumnWidth
Next
MsgBox a
End Sub

I get number 81 - and in the help I read that it the SAME point (???)

Can anybody explain me difference between points in width
in two cases?
At the end I need code like:

Application.wide = "Sum of wides of 10 columns "

Thanks
Leo