Simply use an equality function. Let's say you want to
compare range A1:D10 against range E1:H10 on the same
sheet. In I1 enter =A1=E1 then fill down and across to
match the size of the range. If you are working on two
different worksheets you can use the same idea, using
something like =Sheet1!A1=Sheet2!A1.

-----Original Message-----
Is there a simple way to compare ranges for exactness?
Let's say there are two
ranges of an identical number of cells. One would like to
see if each cell is
of one range is identical to the corresponding range of
the other cell. One
does not care what the difference. One only cares as to
whether the ranges in
total are exact. One could write some code to compare
each cell, cell by cell,
but I was wonder if there were some function that could
be called.

Thanks,
Jeff

.