ActiveWindow.VisibleRange.Width - Is this the correct code

[StevenS]

Is this the correct code to size a cell to the size of a users screen no
matter what the size
'eg
Columns("p:p").ColumnWidth = ActiveWindow.VisibleRange.Width / 8 (8 = factor
to convert to pixels)
--
SS

[Vasant Nanavati]

No. Try the following (no guarantees!) instead of 8 in your denominator:

(Columns("P:P").Width / Columns("P:P").ColumnWidth)

--

Vasant


"StevenS" <StevenS@discussions.microsoft.com> wrote in message
news:41BE99FE-6B76-4F00-9BA0-242CFA553694@microsoft.com...
> Is this the correct code to size a cell to the size of a users screen no
> matter what the size
> 'eg
> Columns("p:p").ColumnWidth = ActiveWindow.VisibleRange.Width / 8 (8 =
> factor
> to convert to pixels)
> --
> SS