"Dave Peterson" wrote in message
I don't see a difference between using this:

If IsError(Application.Match(.Cells(iRow, _
OriginCell.Column).Value, varCodes, 0)) _

And

Dim OriginColIndex as Long
OriginColIndex = OriginCell.Column
then
If IsError(Application.Match(.Cells(iRow, _
OriginColIndex).Value, varCodes, 0)) _


I'd guess it was something else that was the problem.

It probably was. I thought the first version should work as well, that's
why I was asking. I didn't want to start my VBA self-teaching with a
misconception that would make me use extra lines of code when it wasn't
necessary :)

Thanks,
Fiona