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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF