Convert Sort code for Excel 2003

[AdLoki]

Hi All, I have the following macro working in Excel 2007 but it appears not to be compatible with 2003:

Please Login or Register  to view this content.

It's the <ws.Sort.SortFields.Clear> function that appears to be the problem. Can anyone help me to code this so that it's compatible with 2003?

Many thanks,
AdLoki

[Marcol]

Sorry I can't look at your code at the moment.

However this example code might give you a start

Please Login or Register  to view this content.

You don't need to use the if statement, 2007 will handle the 2003 code.

Hope this is of some help.

[AdLoki]

Hi Marcol,

Thanks, this is the line I was already pursuing when you posted your response. Unfortunately, the following code is still kicking out errors

Please Login or Register  to view this content.

I'm now getting a 1004 error (Method 'Range' of object '_Worksheet' failed). Debugger highlights the underlined code above.

I also still haven't figured out how to replicate the <With rge_Sort.Sort> and <rge_Sort.Sort.Clear> functions. Having looked around, I gather it is something to do with 2007 sorting objects which is not back-compatible functionality but, because I'm a n00b, I don't really understand how to resolve this...

Any help is appreciated.

Cheers,
AdLoki

[AdLoki]

Marked as solved, thanks to romperstomper here.

Final code below for completeness.

Please Login or Register  to view this content.