Excel VBA Automation & Macros Flashcards
6 cards from real Excel VBA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Excel VBA Automation & Macros flashcards as text
Which VBA property returns the total number of worksheets in a workbook?
Answer: Worksheets.Count
Worksheets.Count returns the integer count of all worksheet tabs in the specified workbook.
How do you loop through all worksheets in a workbook using VBA?
Answer: Both A and B are valid approaches
You can iterate worksheets using either an index-based For loop or a For Each loop over the Worksheets collection.
Which Excel VBA object model object sits at the top of the hierarchy?
Answer: Application
The Application object is the root of the Excel VBA object hierarchy, representing the Excel application itself.
What does the macro recorder in Excel primarily help with?
Answer: Generating VBA code by recording manual Excel actions
The macro recorder captures manual Excel operations and converts them into equivalent VBA code automatically.
How do you insert a new row above row 5 in VBA?
Answer: Rows(5).Insert Shift:=xlDown
Rows(5).Insert Shift:=xlDown inserts a new blank row above row 5, pushing existing rows down.
Which VBA method sends the active workbook as an email attachment?
Answer: ActiveWorkbook.SendMail Recipients:="email@example.com"
ActiveWorkbook.SendMail sends the workbook as an email attachment using the default mail client installed on the system.