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.
|