This Excel macro allows changing cells in selection based on the first cell in a selection:
If Selection.Cells(1, 1).WrapText = True Then Selection.WrapText = False Else Selection.WrapText = True End If
This is useful in Excel 2003 and bellow. Starting from Excel 2007, there is a button to perform this task on a Task Ribbon.
Be the first to comment