ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   column width (https://www.excelbanter.com/excel-worksheet-functions/222134-column-width.html)

nurse amy

column width
 
what is the equivalent of 1 inch in column width

mdmackillop[_20_]

column width
 

Search Inches in VBA help for information.
This should give you a column 1 inch wide (72 points), but it doesn't
look like it on my screen

Columns(1).ColumnWidth =
Application.InchesToPoints(1)


--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68156



All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com