Hi, Steved. All you need is this:

Range("A5").Activate

*******************
~Anne Troy

www.OfficeArticles.com



"Steved" wrote in message
...
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