Forum Discussion
BMatthews37
Jul 18, 2020Copper Contributor
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 workshe...
NikolinoDE
Jul 18, 2020Platinum Contributor
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)
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)