This isn't exactly what you are looking for but it might help.

You could use the EXACT formula in a range of cells identical to those
used in the two spreadsheets. Any occurences of false would indicate a
difference.

You could also try a macro which selected the set of occupied cells in
one of the sheets and compared one by one to the other.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=548165