what is wrong with this macro line...

[oriches]

what is wrong with this macro line?

Sheets("Data1").Range("I5:J1003").Sort Key1:=Range("J5"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Cheers

Ollie Riches

 

[Lewiy]

What problem are you having with it? It seems to run ok.

 

[Andrew Poulsom]

Two possibilites:

1 Range("J5") is missing a worksheet qualification like:

Key1:=Sheets("Data1").Range("J5")

2 The DataOption1 argument doesn't exist in earlier versions of Excel.

 

[oriches]

it is showing this in themacro debugger:

Run-time error '1004':

The sort reference is not valid. Make sure that it's within the data you want to srt, and the first Sort By box isn't the same or blank.

 

[oriches]

Two possibilites:

1 Range("J5") is missing a worksheet qualification like:

Key1:=Sheets("Data1").Range("J5")

2 The DataOption1 argument doesn't exist in earlier versions of Excel.

Thanks for the help, it was no. 1

Cheers

Ollie Riches