Move a sheet before the first sheet of a Workbook

[JeffSavoie]

Hi !

Is there a fonction that can move a sheet before the actual first one ? (move to first position)

OR, is there anyway to get the name of the sheet in the first position in a workbook ? (so i can do a move before the first sheet returned)

Thanks !

 

[MrExcel]

Worksheets("MySheet").Move Before:=Worksheets(1)

should work....

Also to get the name:
FirstSheet = Worksheets(1).Name

Bill

_________________
MrExcel.com Consulting
This message was edited by MrExcel on 2002-04-11 07:28

 

[JeffSavoie]

Hum... i sould have known that !

Thanks !

 

[JeffSavoie]

This is my new favorite Excel page !