Move a sheet before the first sheet of a Workbook

JeffSavoie · Apr 11th, 2002, 08:26 AM

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 · Apr 11th, 2002, 08:27 AM

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 · Apr 11th, 2002, 08:28 AM

Hum... i sould have known that !

Thanks !

JeffSavoie · Apr 11th, 2002, 08:29 AM

This is my new favorite Excel page !

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 08:26 AM	#1
JeffSavoie New Member Join Date: Apr 2002 Posts: 7	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 !

Apr 11th, 2002, 08:27 AM	#2
MrExcel . Join Date: Feb 2002 Location: Akron, Ohio USA Posts: 789	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 ]

Apr 11th, 2002, 08:28 AM	#3
JeffSavoie New Member Join Date: Apr 2002 Posts: 7	Hum... i sould have known that ! Thanks !

Apr 11th, 2002, 08:29 AM	#4
JeffSavoie New Member Join Date: Apr 2002 Posts: 7	This is my new favorite Excel page !