View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Setting columnwidths

Jason,
Depending what you are trying to achieve, Window.UsableWidth (in points) may
be what you are after.
Then .Column.Width (in points) for each column that you wish to adjust.

NickHK

"Jason Zischke" wrote in message
...
Hi all,

I've got one that has stumped me, I'm tring to set my column widths so

that
they fit to the window size however when using different screen sizes and
different pixel sizes I can't get it working in all cases. I am currently
using the function application.width to grab the window size, if anyone

can
help me that would be greatly appreciated.

Jason Zischke