sort data after import

[ronda]

Hi everyone,
I am looking to do a sort after my data has finished importing. Mayb
something with a time wait? I have the following code that work
however it slows things down tremendously (because it re-sorts ever
line as it is imported)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheets("Detail").Select
Range("K1").Select
Selection.Sort Key1:=Range("K2"), Order1:=xlAscending
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Any ideas would be appreciated.
Thanks

 

[Simon Lloyd]

Hi i found a useful site on timers here..
http://www.enhanceddatasystems.com/ED/Pages/ExcelTimer.htm

Hope this helps,

Simo