go to far left worksheet
 

I will be grateful for a piece of code to take me to the furtherest worksheet
on the far left (in the base of the workbook where the sheet tabs are
displayed ie, the furtherest tab on the left) in a workbook with many sheets

many thanks
--
with kind regards

Spike

go to far left worksheet
 

Sheets(1).Select

HTH
--
AP

"Spike" a écrit dans le message de
...
I will be grateful for a piece of code to take me to the furtherest
worksheet
on the far left (in the base of the workbook where the sheet tabs are
displayed ie, the furtherest tab on the left) in a workbook with many
sheets

many thanks
--
with kind regards

Spike

go to far left worksheet
 

Try:

Sub Macro1()
Worksheets(1).Activate
End Sub
--
Gary''s Student


"Spike" wrote:

I will be grateful for a piece of code to take me to the furtherest worksheet
on the far left (in the base of the workbook where the sheet tabs are
displayed ie, the furtherest tab on the left) in a workbook with many sheets

many thanks
--
with kind regards

Spike