ExcelBanter - View Single Post - ActiveWindow.VisibleRange.Width - Is this the correct code

Thread: ActiveWindow.VisibleRange.Width - Is this the correct code

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming

Stevens

Stevens is offline

external usenet poster

Posts: 19

Default

ActiveWindow.VisibleRange.Width - Is this the correct code

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

Reply With Quote

Reply With Quote