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

It checks values and/or formulas.

"J@@" wrote:

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

Dave Peterson wrote:
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.



Alex St-Pierre wrote:
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

--
Alex St-Pierre


--

Dave Peterson