I have a macro to highlight a row when we are imputing data and it does not allow undo. is there a way to keep the undo history or a better code to use.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ThisWorkbook.Names("ActiveRow")
.Name = "ActiveRow"
.RefersToR1C1 = "=" & ActiveCell.Row
End With
End Sub
Thanks
Steve