VBA code continues to return to specific cell after data is entered

Any suggestions would be greatly appreciated. I am using the Application.Goto reference:=ActiveCell, Scroll:=True and every time data is entered into another cell it returns to the previous referenced cell. I'm not sure how to stop it. Here is an example of my code:

Please Login or Register  to view this content.

Each If statement is evaluated. That means the last If statement that has a Blank cell will determine what cell is selected.

So if range J264 is blank, then A273 will be selected regardless of what cell was just change. As long as J264 is blank, A273 will be selected. And if J264 is not blank, the last previous If-Blank statement that is true will select the cell.

Try something like this. Only the cell that was Changed will evaluate its IF code block.

Please Login or Register  to view this content.

Double check that I got all the range references correct.