Trouble with four key Sort Routine - Excel 2007

[Orada]

This remained unsolved from a previous post so I am hoping some guru might pick up on it and solve it.

I have the sort routing below and despite the fact that I am using Excel 2007 the VBA fails on Key4 with "Compile Error: Named Argument not found"

Please Login or Register  to view this content.

At present I am forced to use the rather long winded Macro generated code and would like to simplify it.

[Colin Legg]

Hi,

The Range.Sort method only accepts 3 keys. This is the same in XL 2007 as previous versions, hence why you get that compile error message.

However, in Excel 2007, a new Sort object was introduced. This is what you need to use instead (don't confuse it with the Range.Sort method you are currently using).
Have a look at the 'Sort Object' topic in your VBA helpfile for further information.

[Orada]

Thanks, that explains everything and of course is very similar to the macro built code.