sort sheets except the first sheet
 

I've got a workbook where the first sheet contains the user instructions and
the remaining sheets are where the user enters the data. I need a macro to
sort the data sheets numerically but not sort the first sheet, which is named
"Instructions." I looked at the Chip Pearson website but I couldn't figure
out how to exclude my first sheet from the sort.

sort sheets except the first sheet
 

If you named your first sheet "_Instructions" (underscore at the beginning),
then it should sort before numbers and so it will remain in position 1.

Hope this helps.

Pete

"Bill_S" wrote in message
...
I've got a workbook where the first sheet contains the user instructions
and
the remaining sheets are where the user enters the data. I need a macro
to
sort the data sheets numerically but not sort the first sheet, which is
named
"Instructions." I looked at the Chip Pearson website but I couldn't
figure
out how to exclude my first sheet from the sort.

sort sheets except the first sheet
 

Or you could use Chip's macro, but at the end, move the Instructions sheet to
the leftmost position.

'almost all of Chip's code
sheets("Instructions").move _
befo=sheets(1)
End Sub

Why fight it <vbg.


Bill_S wrote:

I've got a workbook where the first sheet contains the user instructions and
the remaining sheets are where the user enters the data. I need a macro to
sort the data sheets numerically but not sort the first sheet, which is named
"Instructions." I looked at the Chip Pearson website but I couldn't figure
out how to exclude my first sheet from the sort.

--

Dave Peterson