Excel VBA Programming The Complete Guide - The Workbooks.Count and Worksheets.Count Properties

The video tutorial explains the count properties of worksheets and workbooks in Excel. It begins by detailing how the worksheets count property returns the number of worksheets in an active workbook. It also highlights the difference between worksheets and chart sheets. The tutorial then moves on to the workbooks count property, which provides the total number of open workbooks in Excel. Practical examples are given to illustrate these concepts.

What does the worksheets count property return?

How many types of sheets are available in Excel, and what are they?

What is the difference between the worksheets count and the sheets property?

How can you determine the total number of open workbooks in Excel?

What happens to the workbooks count property when new workbooks are created?