Hello from Steved

Ok I'm in Column AA activating the below macro will take the cursor to A5,
What do i need to do also to scroll to A5. The below macro will take the
cursor to A5 but I cannot see all my worksheet as when saved the cursor will
be in A5 but the worksheet is still showing column AA.

Sub SaveNClose()
Application.Goto Reference:=Worksheets(1).Range("A5").Select
ActiveWorkbook.Close True

Thankyou.
End Sub