Just to make sure I understand... If I had a range  (A1:A30 for example),
and I named  it data, to evaluate the values I'd have to say:

For each cell  in range("data")
If cell.value2 = whatever then do something
Next cell

Something like that? In your experience does the code seem to run faster
using range names, or is it just easier to troubleshoot later on?