View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.