Which part of my autofilter code doesn't work in 2003?

[jamesryan]

Hi,

I have a large amount of code which error's when running in Excel 2003. (it does not sort, whereas in 2007 it does).

As i don't have Excel 2003 can someone tell me which part of my code does not run in Exccel 2003 please:

Please Login or Register  to view this content.

Thanks

[romperstomper]

Everything after the first line - there is no Sort object in 2003. You need to use the range's Sort method - seomthing like:

Please Login or Register  to view this content.

[Marcol]

To add to romperstomper might be worth adding an If statement using version as a criteria

Please Login or Register  to view this content.

[jamesryan]

cheers Romper, you're a star.

Got it sorted now, although very annoying to find more things that don't work in 2003!!

[romperstomper]

That's why it's generally best to develop in the earliest version of Excel that you have to support...

[Marcol]

romperstomper

Agreed, I only suggested the If statement because I like the "new" 2007 sort functions!

[romperstomper]

If you are using Option Explicit, the version check still won't work due to the fact that xlSortOnValues does not exist in 2003, so you would have to declare that constant or use the literal value (0) instead.

[Marcol]

Didn't think of that.

I didn't check using Option Explicit, I'll remember that!

Thanks for the tip.