Named Range or through cells

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

In general, is it faster to go through each cell in a column when
looking for a particular value, or faster to reference a named range
for the area to search?

Thanks, Alan
 
1. It is usually much faster to use the "Find" method.
2. Special cells can help narrow the search.
3. Not accessing the worksheet cells directly but referencing a Range Object
or loading the cell values into a Variant and then looping thru
one or the other is the next choice...

Set rngCol = Range("A10:A1000")
For Each rCell in rngCol
-or-
varRng = Range("A10:A1000").Value
For N = LBound(varRng, 1) To UBound(varRng, 1)
--
Jim Cone
Portland, Oregon USA



"Alan" <[email protected]>
wrote in message
In general, is it faster to go through each cell in a column when
looking for a particular value, or faster to reference a named range
for the area to search?
Thanks, Alan
 
Both are equally fast in properly designed code. The named range approach
means you use less code to restrict the search range, but ultimately it
should execute with equal precision.
 
Back
Top