Forum Discussion
Setting Column Width
I am trying to create a spreadsheet that will create vertical strips of paper that I will be able to print out and use for a project. I need each strip to be 0.34". When I select the entire worksheet and format all columns to 0.34", click OK and then to verify, I right click on the header of a column to check the width it is saying 0.33". If I click OK, then re-check, it says the column is now 0.32". Does anyone know why Excel continues to resize the column rather than keeping it at 0.34"?
1 Reply
- maybe try with VBA....
Sub Adjust_column_width()
With Columns("A:A")
.EntireColumn.AutoFit
If .ColumnWidth > 10 Then
.ColumnWidth = 10
End If
End With
End Sub
I would be happy to find out if I could help.
Nikolino
I know I don't know anything (Socrates)
