Sub SaveNClose()

Steved · Jul 11, 2005

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 · Jul 11, 2005

Try this Steve

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

Steved · Jul 11, 2005

Excellent

Thankyou.

Ron de Bruin said:
Try this Steve

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