How to know if 2 sheets are identicals
 

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

How to know if 2 sheets are identicals
 

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

How to know if 2 sheets are identicals
 

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

How to know if 2 sheets are identicals
 

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

How to know if 2 sheets are identicals
 

Thanks!
I have also seen a good example here (works very well):
http://perso.orange.fr/frederic.sigo...uxFeuilles.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.
--
Alex St-Pierre


"Dave Peterson" wrote:

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