Controlling Screen View

[Varne]

Hi

Could someone help with this please?

I have to run a macro by clicking a rectangle in sheet 1.

After doing a few things it has to end by selecting cells(1,1) in sheet 3.

The problem is the following;

Say when sheet 3 was worked last by somebody he saved and closed it after
working in the FA1:FH10 area.

Now if I run my macro of course it selects cells(1,1) but the screen lies
around FA1:FA10 area. I have to scroll leftwards manually to see cells(1,1).

Kind Regards

M Varnendra

 

[Mike H]

Try

Application.Goto Range("A1"), True

Mike

 

[Gary''s Student]

Application.Goto Reference:=Worksheets("Sheet3").Range("A1"), scroll:=True

 

[Varne]

Hi

That works.

Thank you very much. Have a good day.

M Varnendra