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

Signature
with kind regards
Spike
Ardus Petus - 23 Mar 2006 12:09 GMT
Sheets(1).Select
HTH
--
AP
> 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
Gary''s Student - 23 Mar 2006 12:12 GMT
Try:
Sub Macro1()
Worksheets(1).Activate
End Sub

Signature
Gary''s Student
> 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