Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find optimization
I have some code that searches for a string in two other workbooks.
I set ranges like this: Set retRange = ActiveWorkbook.Sheets("RawData").UsedRange Set rLegacyProd1 = Workbooks("Legacy Shipped - Prod1.xls").Worksheets("RawData").UsedRange Set rLegacyProd2 = Workbooks("Legacy Shipped - Prod2.xls").Worksheets("RawData").UsedRange I use €śfind€ť to look for the value, like this: If first character in sernoStr matches a certain pattern then I search in one workbook or the other: Set mCell = rLegacyProd1.Find(sernoStr, LookIn:=xlValues) Since the workbooks Im searching in are pretty large (~40K records) the macro takes a long time to run. Im looking for suggestions for speeding up the code. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel |