sorting code problems

  • Thread starter Thread starter DKY
  • Start date Start date
D

DKY

I try this code to sort my sheet but end up losing my header (which i
row 1) Can anyone help me figure out why?


Code
 
Change xlGuess to xlYes

Rows("1:61775").Select
Range("C1").Activate
Selection.sort Key1:=Range("C1"), Order1:=xlAscending, Header:= _
xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
 
Hi,
Read the sort parameters, Header =: xlGuess. ( and check the sort
parameters in Help)
Excell did a wrong guess. Change it to xlYes
Regards,

JY
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet sorting code/technique advise 55
Sorting columns horizontally 2
Problem sorting a range of columns using VBA 1
Sort in hidden page crach 8
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Stay on Active Sheet 2
Problem with VBA code not running in Excel 2003 1
Button Problem with the Sort command 7

Back
Top