Setting Column Width

%3CLINGO-SUB%20id%3D%22lingo-sub-1531003%22%20slang%3D%22en-US%22%3ESetting%20Column%20Width%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531003%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20spreadsheet%20that%20will%20create%20vertical%20strips%20of%20paper%20that%20I%20will%20be%20able%20to%20print%20out%20and%20use%20for%20a%20project.%26nbsp%3B%20I%20need%20each%20strip%20to%20be%200.34%22.%26nbsp%3B%20When%20I%20select%20the%20entire%20worksheet%20and%20format%20all%20columns%20to%200.34%22%2C%20click%20OK%20and%20then%20to%20verify%2C%20I%20right%20click%20on%20the%20header%20of%20a%20column%20to%20check%20the%20width%20it%20is%20saying%200.33%22.%26nbsp%3B%20If%20I%20click%20OK%2C%20then%20re-check%2C%20it%20says%20the%20column%20is%20now%200.32%22.%26nbsp%3B%20Does%20anyone%20know%20why%20Excel%20continues%20to%20resize%20the%20column%20rather%20than%20keeping%20it%20at%200.34%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1531003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531024%22%20slang%3D%22de-DE%22%3ERe%3A%20Setting%20Column%20Width%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531024%22%20slang%3D%22de-DE%22%3Emaybe%20try%20with%20VBA....%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Sub%20Adjust_column_width()%20%3CBR%20%2F%3E%20With%20Columns(%22A%3AA%22)%20%3CBR%20%2F%3E%20.%20EntireColumn.Autofit%20%3CBR%20%2F%3E%20if%20.%20ColumnWidth%20%26gt%3B%2010%20Then%20%3CBR%20%2F%3E%20.%20ColumnWidth%20%3D%2010%20%3CBR%20%2F%3E%20End%20If%20End%20With%20End%20Sub%20I%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20help.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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)