VBA Move Sheet

[mahmed1]

Hi Guys,

Quick question

what is the code to move a sheet to the end and at the beginning

i.e move sheet Main to end so the last worksheet tab
move sheet Main to Beginning so the first worksheet tab

Thanks

 

[VoG]

Hi. Try like this

Sheets("Main").Move after:=Sheets(Sheets.Count)

Sheets("Main").Move before:=Sheets(1)

 

[JamesW]

Hi there,

Try the following:

    numSheets = (Application.Sheets.Count)
    Sheets("Main").Move After:=numSheets
    
    Sheets("Main").Move Before:=Sheets(1)

 

[mahmed1]

Thank you guys

What code can i use to sort the sheets in alphabatical order?

 

[mahmed1]

Thank you guys

What code can i use to sort the sheets in alphabatical order?

Bump

Thank you

 

[meldoc]

Hello

See the link.

http://support.microsoft.com/kb/812386