Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then ...
Is there a way to reference the range in some other way, like via its Excel name or by the value in the header row? It's a real pain to fix these macros everytime I move a column.
If Target.Column = 1 Then ...
Is there a way to reference the range in some other way, like via its Excel name or by the value in the header row? It's a real pain to fix these macros everytime I move a column.