Runtime Error in 2003 not in 2007

[Nilchii]

Hi

This code:

ActiveWorkbook.Worksheets("Start").Sort.SortFields.Clear

Is causing a runtime error in Excel 2003, but not in 2007. Any insight as to
why this would be so?

Thanks
Matt

 

[Nick Hodge]

Matt

SortFields was added with the new sort functionality in 2007, therefore 2003
does not understand it. (Always develop on the oldest version to be 'more'
sure)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk