I have a Macro that EE helped me build. What it does is expand the Wrap Text capability so you can type in line after line of text and then it will auto. expand the cell. Very cool!
Here's my question; when I copy a cell, outside the column that is affected by this macro, it auto copies the Wrap Text attribute. Is there a way to limit it to a specific Column?
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
For Each c In Target.Cells
Application.ScreenUpdating = False
c.WrapText = True
If c.WrapText Then c.Rows.AutoFit
Application.ScreenUpdating = True