Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Full Screen View | Excel Discussion (Misc queries) | |||
on-screen view | Excel Discussion (Misc queries) | |||
Row always in screen view | Excel Discussion (Misc queries) | |||
Why can I only view my spreadsheet in full screen | Excel Discussion (Misc queries) | |||
same screen view | Excel Discussion (Misc queries) |