Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sub SaveNClose()
Hello from Steved
If Im working in another sheet but I want it to go the first sheet then save what is required please to the macro below Sub SaveNClose() Application.Goto Reference:="R5C1" ActiveWorkbook.Close True End Sub Thankyou. |
#2
|
|||
|
|||
Try this Steve
Application.Goto Reference:=Worksheets(1).Range("A5") -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello from Steved If Im working in another sheet but I want it to go the first sheet then save what is required please to the macro below Sub SaveNClose() Application.Goto Reference:="R5C1" ActiveWorkbook.Close True End Sub Thankyou. |
#3
|
|||
|
|||
Excellent
Thankyou. "Ron de Bruin" wrote: Try this Steve Application.Goto Reference:=Worksheets(1).Range("A5") -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello from Steved If Im working in another sheet but I want it to go the first sheet then save what is required please to the macro below Sub SaveNClose() Application.Goto Reference:="R5C1" ActiveWorkbook.Close True End Sub Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|