Thread: Sorting problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francis Hookham Francis Hookham is offline
external usenet poster
 
Posts: 125
Default Sorting problem

Any idea why the following runs on laptop with XL 2002 but not on desktop
with XL 2000.

It is in a subroutine called by another. The sub does not start but throws
up the comment 'Named argument cannot be found' and 'DataOption1' is
highlighted?



Range("A1:D" & iCount).Sort Key1:=Range("C1"), Order1:=xlAscending,
Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal



Francis Hookham