Sort.Orientation Query correctness of me or Library document

  • Thread starter Thread starter awrl100
  • Start date Start date
A

awrl100

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,

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
 
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
 
Back
Top