| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cursor goto a5 in Sheet1 but
Hello from Steved
The below macro works as I require. Please If I am working in sheet2 how do I get the cursor please to goto A5 Sub SaveNClose() ActiveWindow.SmallScroll ToRight:=-25 Application.Goto Reference:=Worksheets(1).Range("A5") ActiveWindow.SmallScroll ToRight:=-25 ActiveWorkbook.Close True End Sub Thankyou. |
|
#2
|
|||
|
|||
|
Ignore please
"Steved" wrote: Hello from Steved The below macro works as I require. Please If I am working in sheet2 how do I get the cursor please to goto A5 Sub SaveNClose() ActiveWindow.SmallScroll ToRight:=-25 Application.Goto Reference:=Worksheets(1).Range("A5") ActiveWindow.SmallScroll ToRight:=-25 ActiveWorkbook.Close True End Sub Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modifying Sheet1 macro to run on Sheet2 | Excel Discussion (Misc queries) | |||
| Looking for comparable data records between Sheet1 and Sheet2 | Excel Discussion (Misc queries) | |||
| can i type sheet1 A5 and make it show Sheet2 A6 cell | Excel Discussion (Misc queries) | |||
| Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
| Moving from 1 row sheet1 to sheet2 | Excel Worksheet Functions | |||
Linear Mode
