Sort.Orientation Query correctness of me or Library document

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.
 
M

Matthew Herbert

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
 
A

awrl100

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top