Solved: Sort Defined Range

[flea333]

Why will this code not work, error says the object doesn't support this method.
Define the range:
[VBA]Set Data = Range(.Cells(DataStart - 1, i), .Cells(Rows.Count, i).End(xlUp))[/VBA]

Now sort the range:
[VBA]Sheets("AutoList").Data.Sort (Sheets("AutoList").Data.Cells(2, 1))[/VBA]

[Bob Phillips]

Maybe this would work

[vba]

Set Data = .Range(.Cells(DataStart - 1, i), .Cells(.Rows.Count, i).End(xlUp))
[/vba]

but without seeing the context, all the code/workbook, it is hard to be sure.

[flea333]

"Sort method of Range class failed"

[mdmackillop]

Try
[VBA]
Set Data = Range(.Cells(DataStart - 1, i), .Cells(Rows.Count, i).End(xlUp))
Data.Sort Data(2)

[/VBA]