ActiveSheet.Cells.WrapText changes when ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value

[drom]

Hi and Thanks in advance


ActiveSheet.Cells.WrapText is always equal to false

I would like to know why when I do this:

ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value

some of the cells within my usedrange's WrapText becomes True

and if I have to use always when trying to do accomplish that:

ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value
ActiveSheet.Cells.WrapText = True