First Sheet

[Steved]

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.

 

[Bob Phillips]

Sub Test ()
Sheet1.Select
Range ("A2").Select
End Sub


--

HTH

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

 

[Steved]

Thankyou very much.

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


--

HTH

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





.

 

[Steved]

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.

 

[Bob Phillips]

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]

Hello from Steved

I see the problem Sheet3(Otara Service).
I've now inserted a Worksheet and now reads Sheet1(Otara
Service).

Thankyou.

So to recap I've over several files, so as long as it has
Sheet1(NAME) I can use 1 macro to execute the lot.

Thankyou

 

[Bob Phillips]

Yes, because you are referencing the codename of the sheet, and that does
not change when someone renames the sheet. All workbook sheets will have a
codename and an Excel name.

--

HTH

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

 

[Steved]

Thankyou.

-----Original Message-----
Yes, because you are referencing the codename of the sheet, and that does
not change when someone renames the sheet. All workbook sheets will have a
codename and an Excel name.

--

HTH

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





.