Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SaveNClose
Hello from Steved
Please if I am working in an other worksheets and I want it to goto A5 before it goes to A5 in Worksheet1 and saves what is required Sub SaveNClose() Application.Goto Reference:=Worksheets(1).Range("A5") ActiveWorkbook.Close True End Sub Thankyou. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub SaveNClose() | Excel Worksheet Functions |