View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Michel Pierron Michel Pierron is offline
external usenet poster
 
Posts: 214
Default resizing columns with pixels

Sorry Andy;
You must use the width property and not columnwidth.
MsgBox Columns(1).Width 'Points
MsgBox Columns(1).Width * 4 / 3 'Pixels
Regards

"Andy" a écrit dans le message de
...
I want to be able to specify column widths in pixels
rather than points. I can call the function for column
widths in VBE but can't find an option to specify a width
in pixels (even though this value is always shown when
manually resizing)

Help would be great,
Cheers
Andy