| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Programming | |||
| Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
| Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming | |||
Hybrid Mode
