Excel 2007 : Sort Sheet alphabetically.

**GaidenFocus** · 12-06-2010, 04:03 PM

I need to know how to sort my tabs or sheets. the thing is i have a code that sorts ALL of my sheets alphabetically, but i need this macro to leave the others as is, and just sort the new sheet.

This is my create sheet macro, it works great, but it throws it at the end of my workbook. i need it to put it alphabetically with the others.

Please Login or Register  to view this content.

this is my sort sheets macro, but i dont want to do this every time i create one single sheet as it takes about 10 minutes for this macro to finish.

Please Login or Register  to view this content.

thanks in advance

**JBeaucaire** · 12-06-2010, 06:42 PM

Maybe this:

Please Login or Register  to view this content.

**GaidenFocus** · 12-06-2010, 06:58 PM

I'm getting a subscript out of range error. =\

**JBeaucaire** · 12-06-2010, 07:09 PM

Since it works for me, I'd have to see your workbook to understand the problem.

**tigertiger** · 12-06-2010, 07:52 PM

Originally Posted by GaidenFocus

I'm getting a subscript out of range error. =\

the range may be merged cell , plz check it again

**GaidenFocus** · 12-08-2010, 12:37 PM

yea i can't post the workbook, it contains alot of sensitive information.

this is the line its giving me the error with.

Please Login or Register  to view this content.

**JBeaucaire** · 12-08-2010, 02:27 PM

Since all we're working on now is sorting by sheet name, post your workbook without the data in it. We can test just that part on your actual sheet names.