VBA Goto is shifting the view

[Jasesair]

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.

If Target.Address = Range("$f$6").Address Then
Application.Goto Range("e14"), True

 

[aRandomHelper]

Try Range("e14").Select instead

 

[Peter_SSs]

.. or this

If Target.Address = Range("$f$6").Address Then
Application.Goto Range("e14"), True

BTW, here is another simplification for your code

If Target.Address = Range("$f$6").Address Then
If Target.Address = "$F$6" Then

 

[Jasesair]

Well, that was a bit simple. Both methods work perfectly!!! Thanks folks.

 

[Peter_SSs]

You're welcome. Glad we could help.