| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data csv file - tab delimited - and sort to column | Excel Discussion (Misc queries) | |||
| Auto-Import and sort data in Excel | Excel Worksheet Functions | |||
| import text and sort data into excel | Excel Worksheet Functions | |||
| import text and sort data into excel | Excel Worksheet Functions | |||
| how do i import data from excel, sort it then that information is. | Excel Discussion (Misc queries) | |||
Linear Mode
