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