I have the below code that works sufficiently but I'm not certain it's actually right for me. F6 has a data validation list. Once something is selected from the list, I want the cursor to move to cell E14 (both on the same sheet). The below code is doing this but is shifting the view so that column E is the left-most. I'd really like this change not to happen so that the user still sees from Column A.
VBA Code:
If Target.Address = Range("$f$6").Address Then
Application.Goto Range("e14"), True