Runtime Error in 2003 not in 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nilchii - 23 Apr 2007 18:28 GMT

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

Reply to this Message

Nick Hodge - 23 Apr 2007 19:44 GMT

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)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
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

> Hi
>
[quoted text clipped - 8 lines]
> Thanks
> Matt

Reply to this Message