LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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).


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Ranges Graham Excel Discussion (Misc queries) 0 July 24th 07 01:24 PM
Dynamic Ranges patrick Excel Discussion (Misc queries) 2 July 22nd 07 04:53 AM
Dynamic Ranges? Smonczka Excel Programming 2 May 13th 05 03:20 AM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM
Dynamic Ranges Q John[_78_] Excel Programming 6 December 9th 04 04:07 AM


All times are GMT +1. The time now is 05:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"