Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I download financial data from a company's website. Some
of the data arrives as follows: ABC102 120.123 14-01-2005 ABC Fund ABC102 120.246 17-01-2005 ABC Fund Because I use vlookup to find "ABC102", the duplicate data rows foul up the lookup function, so I use a loop in VBA to find the row with the earlier date (14-01-2005) then delete that row. There are about 16000 row of data with about 3000 rows to delete. I cannot sort by date and eliminate all the 14-01-2005 rows because some are valid. At first it took a minute or so to run, but lately it has slowed down to about deleting a row per second and it takes forever! Does anyone know why is it now taking so long to delete the row and any ideas how to speed it up? Is the worksheet running out of rows to delete? I have a Dell P4 2.66 with 512 meg of RAM. Thank-you! Merlin Stewart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |