flea333
08-24-2010, 08:26 PM
Why will this code not work, error says the object doesn't support this method.
Define the range:
Set Data = Range(.Cells(DataStart - 1, i), .Cells(Rows.Count, i).End(xlUp))
Now sort the range:
Sheets("AutoList").Data.Sort (Sheets("AutoList").Data.Cells(2, 1))
Define the range:
Set Data = Range(.Cells(DataStart - 1, i), .Cells(Rows.Count, i).End(xlUp))
Now sort the range:
Sheets("AutoList").Data.Sort (Sheets("AutoList").Data.Cells(2, 1))