How to know if 2 sheets are identicals

[Guest]

Hi,
I'm wondering if there's a way to know if two sheets are identicals?
i.e. same value, same format, same borders, same column width and row height
Thank you!
Alex

 

[Dave Peterson]

I think the only way to do it is to go through each cell and compare each of the
properties that you want to check with the corresponding cell in the other
sheet.

 

[J@@]

Or you could use Compare.xla from Chip pearson
http://www.cpearson.com/excel/whatsnew.htm
HTH
J@@

 

[Dave Peterson]

It might be a nice start, but IIRC, it won't check columnwidths, rowheight, and
formats.

It checks values and/or formulas.

Or you could use Compare.xla from Chip pearson
http://www.cpearson.com/excel/whatsnew.htm
HTH
J@@

 

[Guest]

Thanks!
I have also seen a good example here (works very well):
http://perso.orange.fr/frederic.sigonneau/code/Feuilles/ComparerDeuxFeuilles.txt (in french)
It test value and formula like compare.xla and display the difference into a
new workbook. I'll add the others tests inside the macro.