View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Guy Normandeau Guy Normandeau is offline
external usenet poster
 
Posts: 29
Default Efficiency of Dynamic ranges

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).