Cell A = Cell B; CellB = CellA

Originally Posted by gomez87

Hello Guys.

I am trying to make 2 cells equal too each other regardless of where I input the value ( A or B).

Here is the code I am currently trying.

The code does seem to be doing the task. However, excel is crashing after running this code.

Private Sub Worksheet_Change(ByVal Target As Range)

Please Login or Register  to view this content.

Thank you.
E.

Your code is handling change events, but is then changing the worksheet which in turn causes a change event,etc. Maybe try this. Before making a change in your sub, Application.EnableEvents = False, and then before the end of the Sub, Application.EnableEvents = True

That did the trick.

Thank you!

Originally Posted by klvaughnsd

Your code is handling change events, but is then changing the worksheet which in turn causes a change event,etc. Maybe try this. Before making a change in your sub, Application.EnableEvents = False, and then before the end of the Sub, Application.EnableEvents = True

Originally Posted by gomez87

That did the trick.

Thank you!

You're welcome!