Excel: Very frustrating, top record of selection won't sort

[Benoni2]

Weird, I have a list of names in a column that I want to sort alphabetically. When I try to sort, it leaves the top value selected and sorts all those below it. I am working with vba taking the values elsewhere once sorted, but it should affect this part of it. Any idea why the top value remains stationary?

 

[ck1999]

make sure it is not using the top row for column headers.

What version of office?

Post the code please


ck1999

 

[AnotherHiggins]

Adding [COLOR=blue white]Header:= xlNo[/color] to the code will probably help, but a better practice is to select the entire dataset before sorting.

Like ck1999 said, it will be much easier to help you if you show us what you have already tried.

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Benoni2]

I think that is exactly what it was. It was thinking it was a header. I used a "follow my actions" macro and it wrote in there a "header:=xlGuess". So for whatever reason initially it seemed to work. but then after that it seemed to do it wrong. So now it is set to no. Thanks for the help.

 

[AnotherHiggins]

Glad to help.


[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.