Sub SaveNClose()

[Guest]

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.

 

[Ron de Bruin]

Try this Steve

Application.Goto Reference:=Worksheets(1).Range("A5")

 

[Guest]

Excellent

Thankyou.

Try this Steve

Application.Goto Reference:=Worksheets(1).Range("A5")