Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change default for sort ?
I want to change the default from header row to NO header row when
sorting. Know where this setting is? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change default for sort ?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
change default for sort ?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
change default for sort ?
Allen,
As you posted in the .programming group I thought that you were looking for a VBA solution. Seeing as your not, in re-evaluating your question, there isn't a defualt, per se, for that option nor is there a way to set it. This is one of those "Bill is infinitely smarter than you and He 'knows' what you want to do better than you do" type of features. Excel isn't too bad, but the ones in Word can be very difficult to get around. Anyway, when you try to do a sort, Excel evaluates the range that you're trying to sort. If the top row (or even the row above the selected range) is formatted differently from the rest of the range, Excel will "assume" a header row and set it as a "default". If it's not formatted differently and doesn't "look" like it might somehow be a header row, Excel will assume that it isn't. John "Allen" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Default | Excel Discussion (Misc queries) | |||
Sort w/o header row - change default | Excel Worksheet Functions | |||
Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
Default Sort Order | Excel Worksheet Functions | |||
excel change default column sort to current selection | Excel Worksheet Functions |