Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all
I am trying to set the width of coloumns to 16 pixels. I know I cannot set that directly, so in stead I try to set the columnwidth, and adjust it by reading the width. Result: A is alway 0 - hidden :-) and the following C E etc are 22 pixels, 1.57 chars. What do I do wrong? WBR Sonnich for($j=0;$j<$h;$j++) { $WB-Sheets(1)-Columns($j*2+1)-ColumnWidth=1; while($WB-Sheets(1)-Columns($j*2+1)-Width < 16) $WB-Sheets(1)-Columns($j*2+1)-ColumnWidth = $WB-Sheets(1)-Columns($j*2+1)-ColumnWidth + 0.1; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting column width to specific row in Excel doc ??? Thanks! | Excel Discussion (Misc queries) | |||
How to initialize the column width from pixels. Pixel to Char conversion | Excel Programming | |||
How to initialize the column width from pixels. Pixel to Char conversion | Excel Programming | |||
Open JPG and determine pixel width in VB? | Excel Programming | |||
with same font and pixel number different column width | Setting up and Configuration of Excel |