View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sonnich Jensen[_2_] Sonnich Jensen[_2_] is offline
external usenet poster
 
Posts: 11
Default Setting width in pixel in Excel

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;