Hi John, Thanks for the answer.
I have never used vba, I basiacally understand the code below.
I think it is about time I learned.
I do not know where to start. Could you point me in the right
direction :-)

On Mon, 18 Aug 2003 19:35:07 -0400, "John Wilson"
wrote:

Allen,

Your choices in VBA (from the Help file) a

Header:=xlGuess
Header:=xlYes
Header:=xlNo

John

"Allen" wrote in message
.. .
I want to change the default from header row to NO header row when
sorting.
Know where this setting is?

TIA