Set the scroll bar at the Left (column A)

[abadilala]

Hi, I have a macro and it perfectly run. however, the result is always shown at the right (latest column).
image attached http://ibb.co/maG9L6
I tried to add the macro
select.range("A1") or Application.Goto Reference:="R1C1" and it still not working.

Is there anyone know how to make the scroll bar at the left (column A) when first open?

 

[jmacleary]

Add this at the end:

Range("A1").Select


Regards
John

 

[abadilala]

still not working