Excel '07 macro breaks in '03: Multiple levels of sorting

**dinerroll** · 06-13-2011, 10:38 AM

Hello All,

I'm writing because I have a worksheet and macro that I use on a machine with Excel '07. I've been able to build all of the logic of the macro I inherited to be compatible with Excel 2003 except for this issue with multiple levels of sorting. The code that breaks in Excel 2003 is below... I get a runtime error that "object doesn't support this property or method)...any workarounds? They don't have to be pretty. This workbook is being used by 8 people who all work in the same room.

Please Login or Register  to view this content.

**romperstomper** · 06-13-2011, 10:42 AM

The Sort object was added in 2007. You'll need to use the Range.Sort method and do three sorts - first on O, R and S; then on H, E and J; and lastly on A, B and D.

**dinerroll** · 06-13-2011, 10:46 AM

Hey romperstomper. Thanks for the quick reply. I used to just used SQL to do most of my data analysis, so I really don't have any VBA experience. Can you give just a quick example of what the code for that would look like for one of the sorts?

**romperstomper** · 06-13-2011, 10:56 AM

For example:

Please Login or Register  to view this content.

**dinerroll** · 06-13-2011, 11:02 AM

Thank you so much dude. I came up with

Please Login or Register  to view this content.

But your solution looks way better. Thank you so much for the original suggestion and this code.

**romperstomper** · 06-13-2011, 11:36 AM

Glad to help.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save