sort data after import
 

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

--
rond
-----------------------------------------------------------------------
ronda's Profile: http://www.excelforum.com/member.php...fo&userid=1036
View this thread: http://www.excelforum.com/showthread.php?threadid=31992

sort data after import
 

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

Hope this helps,

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=31992