LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
application.match and value problem Cbrehm Excel Discussion (Misc queries) 0 February 12th 11 04:34 PM
Application.OnKey problem Phillip Reeves[_2_] Excel Programming 1 January 23rd 04 06:46 PM
Application Problem Stuart[_10_] Excel Programming 7 November 16th 03 05:44 PM
Problem width width-property Tom Excel Programming 2 August 23rd 03 03:45 AM
Problem in running an application Mohanasundaram[_2_] Excel Programming 0 August 5th 03 08:26 AM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"