Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort.Orientation Query correctness of me or Library document
I am a very inexperienced Office Developer (assuming I even qualify as one).
I query whether a document under MSDN Library might be incorrect; however, I believe it is more likely that the error will lie with my understanding. Under the 'Excel 2007 Developer Reference' the document for the property "Sort.Orientation" (http://msdn.microsoft.com/en-us/library/bb148040.aspx) appears to contradict the code example in the document "Sort Object" (http://msdn.microsoft.com/en-us/library/bb178505.aspx). The value constants in the "Sort.Orientation" document ("xlSortColumns" and "xlSortRows") raise a runtime error '1004'; the vlaue in the "Sort Object" document ("xlTopToBottom") does not riase this error. Can somebody please shed some light on this for me as it is clouding my understanding of the Sort Object. -- Anthony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort.Orientation Query correctness of me or Library document
Anthony,
If you open the Object Browser (F2 from VBE) and search "xlSortOrientation," you'll notice that the "Members of 'XLSortOrientation'" are xlSortColumns and xlSortRows. If you click on xlSortColumns, you'll notice it has a value of 1 (as noted in the window just below the "Classes" section), and you'll also notice that xlSortRows has a value of 2. Additionally, if you search "xlTopToBottom," you'll notice that it is part of the "Constants" class and has a value of 1. So, it won't matter whether you use xlSortColumns or xlTopToBottom because both have a value of 1. All the following are equivalent: .....Sort.Orientation = xlSortColumns .....Sort.Orientation = xlTopToBottom .....Sort.Orientation = 1 I hope this helps. Best, Matthew Herbert "awrl100" wrote: I am a very inexperienced Office Developer (assuming I even qualify as one). I query whether a document under MSDN Library might be incorrect; however, I believe it is more likely that the error will lie with my understanding. Under the 'Excel 2007 Developer Reference' the document for the property "Sort.Orientation" (http://msdn.microsoft.com/en-us/library/bb148040.aspx) appears to contradict the code example in the document "Sort Object" (http://msdn.microsoft.com/en-us/library/bb178505.aspx). The value constants in the "Sort.Orientation" document ("xlSortColumns" and "xlSortRows") raise a runtime error '1004'; the vlaue in the "Sort Object" document ("xlTopToBottom") does not riase this error. Can somebody please shed some light on this for me as it is clouding my understanding of the Sort Object. -- Anthony |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort.Orientation Query correctness of me or Library document
Thank you Matthew. What a surprise... the fault turned out to lie with me. I
incorrectly interpreted xlSortRows as 'sort BY rows' instead of 'sort THROUGH rows'. Your post drawing attention to the evaluation of these constants provided the breakthrough. When I used "xlSortColumns" equating to "xlSortTopToBottom" ,no error, output was as designed. Best Regards -- Anthony "Matthew Herbert" wrote: Anthony, If you open the Object Browser (F2 from VBE) and search "xlSortOrientation," you'll notice that the "Members of 'XLSortOrientation'" are xlSortColumns and xlSortRows. If you click on xlSortColumns, you'll notice it has a value of 1 (as noted in the window just below the "Classes" section), and you'll also notice that xlSortRows has a value of 2. Additionally, if you search "xlTopToBottom," you'll notice that it is part of the "Constants" class and has a value of 1. So, it won't matter whether you use xlSortColumns or xlTopToBottom because both have a value of 1. All the following are equivalent: ....Sort.Orientation = xlSortColumns ....Sort.Orientation = xlTopToBottom ....Sort.Orientation = 1 I hope this helps. Best, Matthew Herbert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
working out % of correctness gives #DIV/0! | Excel Discussion (Misc queries) | |||
Convert Excel document to PDF with different page orientation | Excel Discussion (Misc queries) | |||
Advice on correctness of using subs | Excel Programming | |||
How can I display a value from a spreadsheet cell in a column in a document library? | Excel Programming | |||
Sort Orientation | Excel Programming |