VBA in 2007 v 2003

**BRISBANEBOB** · 01-15-2009, 11:31 PM

Can anyone advise me why the line

ActiveWorkbook.Worksheets(CurrentWorksheet).Sort.SortFields.Clear

from the code below works fine in Exccel 2007 but falls over in 2003, and is there a workaround?

Please Login or Register  to view this content.

Thanks for any help

**royUK** · 01-16-2009, 03:02 AM

I think SortFields only applies to 2007

**BRISBANEBOB** · 01-16-2009, 03:05 AM

thank you - I think you're right

IS there a 2003 equivalent?

**royUK** · 01-16-2009, 03:14 AM

I hink you can just use Sort, test for version using application.version to determine which code to run.

**BRISBANEBOB** · 01-18-2009, 05:32 PM

Thanks, Roy. I eventually found it after about ten hours - I must do a course in VBA because hacking through a problem all the time is not the way to go about it...

Thanks for your help

VBA in 2007 v 2003

LinkBack

Thread Tools

Rate This Thread

Display

VBA in 2007 v 2003

Thanks

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions