Excel VBA Excel VBA Automation & Macros 3

Question 1

Which VBA property returns the total number of worksheets in a workbook?

Accepted Answer

Worksheets.Count

Answer

Workbook.SheetCount

Answer

Sheets.Total

Answer

ActiveWorkbook.PageCount

Question 2

How do you loop through all worksheets in a workbook using VBA?

Accepted Answer

Both A and B are valid approaches

Answer

For i = 1 To Worksheets.Count

Answer

For Each ws In ActiveWorkbook.Worksheets

Answer

While Not Worksheets.IsLast

Question 3

Which Excel VBA object model object sits at the top of the hierarchy?

Accepted Answer

Application

Answer

Workbook

Answer

Worksheet

Answer

Excel

Question 4

What does the macro recorder in Excel primarily help with?

Accepted Answer

Generating VBA code by recording manual Excel actions

Answer

Automatically debugging VBA code

Answer

Running macros on a schedule

Answer

Exporting VBA modules to text files

Question 5

How do you insert a new row above row 5 in VBA?

Accepted Answer

Rows(5).Insert Shift:=xlDown

Answer

Rows(5).AddAbove()

Answer

Rows(5).Insert()

Answer

Cells(5).InsertRow()

Question 6

Which VBA method sends the active workbook as an email attachment?

Accepted Answer

ActiveWorkbook.SendMail Recipients:="email@example.com"

Answer

ActiveWorkbook.Email()

Answer

Application.MailWorkbook("email@example.com")

Answer

Outlook.SendWorkbook()