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
|