Trouble with sort code in macro

[maacmaac]

I have a sort function in one of my macro. Sometimes it works, sometimes it does not. I can't figure out why. I am trying to sort columns A-F and each column has a header.

Please Login or Register  to view this content.

I am thinking it is because of

Please Login or Register  to view this content.

but I may be wrong. Any thoughts as to why it keeps blowing up? Thanks.

[Leith Ross]

Hello maacmaac,

Since you do have headers, change the header argument to yes and the Orientation.

Please Login or Register  to view this content.

[maacmaac]

Leith,

Your solution worked except for change the Orientation to SortRows. I'm not sure why I would use SortRows in the Orientation. When I execute the code this way it is doing the sort left to right, not top to bottom. I had to revert back to TopToBottom for the Orientation. Otherwise I am marking as solved. Code is now as follows:

Please Login or Register  to view this content.

Thank you for the comment.