Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is is more efficient to use? I would need to know when the range is
evaluated. Is it at the beginning or everytime it is referenced. When you use 'set vRange = range('tRagen")' is the vRange re-evaluated everytime it is used as in 'set rValue = rRange.find(...)'. Is there a place that would give optimization tips. Sample 1: dim rRange as range dim rValue as range set rRange = range("tRange") .... set rValue = rRange.find(<variable, lookin:=xlValues) Versus Sample 2: dim rValue as range .... set rValue = range("tRange").find(<variable, lookin:=xlValues) The 'find' will be executed at variaous times between 150000 - 200000 times. (I have many sources of data). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Ranges | Excel Discussion (Misc queries) | |||
Dynamic Ranges | Excel Discussion (Misc queries) | |||
Dynamic Ranges? | Excel Programming | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Dynamic Ranges Q | Excel Programming |