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"
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