Compare Everything in Excel Part 2.1: Worksheet Properties

Check also and download CompareXLS Excel Addin here: https://excelmacrobusiness.blogspot.com/2023/01/excel-comparexls-add-in.html

This is part of a mini-series to learn to how to compare everything in Excel using VBA macros. In this video we see how to compare worksheet properties. We can use this to compare two or more worksheets. Worksheet properties may include the name, used range, number of cells with content, whether the sheet is visible, or protected, number of formulas, validations, comments, conditional formatting, hyperlinks, charts, pivots, shapes, etc. Additionally, we also have a look at CompareXLS, which is a powerful Excel Add-in that allows to compare workbooks, worksheets, and datasets. In the next video of this mini-series (Compare everything in Excel), we will see how to compare worksheet cell-to-cell values, formulas, or formatting.

You can find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners) in the blog under the link: https://excelmacroclass.blogspot.com/

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)

Видео Compare Everything in Excel Part 2.1: Worksheet Properties канала Excel Macro Mania