Ah thanx that did it.


Appreciate everyones help.

Have a good day!
-----Original Message-----
Todd,

remove the ":" after "A"


In article ,
"Todd Huttenstine"
wrote:

Well its looping through correctly, but then when it
finds
a cell that equals the #N/A error, it hits the
following
line of code...

Sheets("Mismatches").Range("A:" & Sheets
("Mismatches").Range("H2").Value) = cell1

I get the error Runtime error 1004 Application defined
or
object defined error.
.