Hi
Is there anyway to get excel to not round off when adjusting the column width? For example, I set the column width specifically as such:
Columns("O:O").Select
With Selection
.HorizontalAlignment = xlLeft
End With
Selection.ColumnWidth = 8.43
Yet when I check the width afterwards, it is at 8.5
It does this with all the columns where it rounds it off to a single decimal as opposed to two places
Columns need to be formatted to an exact size since they are exported to a formatted text (space deliminated) file format which is very dependant on the column width
Any ideas on how to keep two, and not one decimal place when setting the column width?
Thank You
Bookmarks