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