View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Moving sheets in code

Worksheets("Clusters Summary Report").Move befo=Worksheets(1)

--
HTH...

Jim Thomlinson


"Ayo" wrote:

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

Worksheets("Clusters Summary Report").Move befo=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?