Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2003
When I run the program below, the debug shows: 50.58 and 50.57 I then physically measure the 6 columns and get 9.5 centimeters and then measure column 10 and get 8.5 centimeters. Does anybody know what's going on here? ------------------------------------------------------------------------- sub doit Dim widthOfSixColumns As Single Dim columnTenWidth As Single widthOfSixColumns = Sheets("sheet1").Columns(1).ColumnWidth * 6 Sheets("sheet1").Columns(10).ColumnWidth = Sheets("sheet1").Columns(1).ColumnWidth * 6 columnTenWidth = Sheets("sheet1").Columns(10).ColumnWidth end sub Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Columnwidth | Excel Discussion (Misc queries) | |||
Change ColumnWidth for Multiple Columns? | Excel Programming | |||
ColumnWidth | Excel Programming | |||
what do i change in options to correct | Excel Discussion (Misc queries) | |||
ColumnWidth | Excel Programming |