Should work okay.

Go into the VBE, and for that workbook, look in the Project Explorer. You
should see an item Sheet1(Otara Service). If not, what do you see alongside
Otara Service? That is what you should use instead of Sheet1.Select.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steved" wrote in message
...
Hello From Steved

I've renamed Sheet1 to Otara Service
Why will the below macro not goto Sheet1

Sub SaveNClose()
Range("B5").Select
Sheet1.Select
Range("B5").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

Thankyou.
-----Original Message-----
Sub Test ()
Sheet1.Select
Range ("A2").Select
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steved" wrote in
message
...
Hello From Steved

I've would like to know please, can the below macro
be change so that no matter what I name Sheet1 it will
return to sheet1, as an example I'm working in sheet 12.


Sub Test ()
Sheets (" Special Kilometres").Select
Range ("A2").Select
End Sub

Thanks in advance.


.