Moving sheets in code

[Ayo]

I want to perform the action in the code line below:

Worksheets("Clusters Summary Report").Move before:=Worksheets("Cluster 1")

This works fine, but the problem is "Cluster 1" is not always going to be
the first worksheet inj the workbook. I am looking for a say to tell the code
to move sheet "Clusters Summary Report" into the first position in the
workbook so that the first worksheet in the workbook is "Clusters Summary
Report".
Is there a way to do this?

 

[Jim Thomlinson]

Worksheets("Clusters Summary Report").Move before:=Worksheets(1)

 

[Gord Dibben]

Worksheets("Clusters Summary Report").Move before:=Sheets(1)


Gord Dibben MS Excel MVP