Running any macro always clears the list of changes so that after you run
the macro you cannot go back and undo changes before it ran, or the changes
made by the macro.
You are running the macro every time you change the active cell (selection)
on the worksheet, so although the macro itself does n
Hi All,
I've macro like:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B23:HH400")) Is Nothing Then
ActiveWorkbook.Names("ActiveRow").RefersTo = "=" & ActiveCell.Row
End If
End Sub
unfortunately I can't undo any changes. Is the anyway
