Hi -
Does anyone know of a more efficient way to code this formatting of a column? It works fine, I just wanted to know if there is a better way of doing this.
Thanks!
Just a piece of the code:
![]()
' Column B Columns("B:B").ColumnWidth = 14.71 Columns("B:B").Select Selection.NumberFormat = "ddd h:mm" With Selection .HorizontalAlignment = xlLeft .VerticalAlignment = xlTop .WrapText = True .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks