Help on Macro to Sort Date

[Grepees]

I need help with a marcro i have that sorts dates. I have been using this Macro for years now. I just moved this into another file and when i run it, it returns an error message (shown below the code). The only difference is that this file has multiple columns with dates and i want to sort by column N. Any help would be very much appreciated. Thanks.


Sub SortByDate()
With Sheets("Customer List")
With .Range("N3").CurrentRegion
.Sort Key1:=.Columns(14 - .Column + 1), Order1:=xlAscending, Header:=xlYes

End With
End With
End Sub

 

[myall_blues]

You might wish to read up about Error 400 and it's causes, as it suggests a deeper issue.