sort sheets except the first sheet

  • Thread starter Thread starter Bill_S
  • Start date Start date
B

Bill_S

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.
 
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
 
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 _
before:=sheets(1)
End Sub

Why fight it <vbg>.
 
Back
Top