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.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Alan" wrote:

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