formatting columns with formula results
 

"Mika Oukka" wrote in message
...
Hello Erik,

How about if you remove the label temporarily before autofitting:

Range("B1:D1").Select 'Assumed LabelRow = 1
For Each cell In Selection
OrigLabel = Cells(1, cell.Column).Value
Cells(1, cell.Column).Value = ""
Columns(cell.Column).EntireColumn.AutoFit
Cells(1, cell.Column).Value = OrigLabel
Next

Mika Oukka

Mika,

Yes it works, however if the label is wider than the autofit has allowed for
I run into the same problem restoring the label.

Erik