I am having trouble with Excel automation, I am trying to sort on column 7 within the spreadsheet from within vfp. The latest code I am using is

.range(.cells(1,1),.cells(65536,256)).sort(.range(.cells(1,7),.cells(65536,7)),xlDescending,xlGuess,1,"False",xlToptoBottom)

I got this code from looking at the macro within Excel, but no matter what I try I am either getting an error or it doesn't sort. If any one can help with this, it would be appreciated.

Darren Donald