ExcelBanter - First Sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - First Sheet (https://www.excelbanter.com/excel-worksheet-functions/15597-first-sheet.html)

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.

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.

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" 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.

.

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.

.

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.

.

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

-----Original Message-----
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.

.

.

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

-----Original Message-----
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.

.

.

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)

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

-----Original Message-----
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.

.

.

.