Controlling Screen View
 

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

Controlling Screen View
 

Try

Application.Goto Range("A1"), True

Mike

"Varne" wrote:

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

Controlling Screen View
 

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

--
Gary''s Student - gsnu200797


"Varne" wrote:

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

Controlling Screen View
 

Hi

That works.

Thank you very much. Have a good day.

M Varnendra



"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200797


"Varne" wrote:

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