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. |
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. |
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. |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com