Excel VBA Excel VBA Data Manipulation & Arrays 2

Question 1

Which VBA method copies a range of cells to another location?

Accepted Answer

Range.Copy()

Answer

Range.Copy() copies the specified range to the clipboard or directly to a destination range.

Question 2

How do you find the last used row in column A using VBA?

Accepted Answer

Cells(Rows.Count, 1).End(xlUp).Row

Answer

Cells(Rows.Count, 1).End(xlUp).Row navigates up from the bottom of column A to find the last non-empty row.

Question 3

Which VBA property returns the number of rows in a worksheet?

Accepted Answer

Rows.Count

Answer

Rows.Count returns the total number of rows available in the active worksheet (1,048,576 in modern Excel).

Question 4

What does the Range.AutoFilter method do in VBA?

Accepted Answer

Applies or removes dropdown filter controls on a range

Answer

Range.AutoFilter applies or toggles the AutoFilter dropdowns on the specified range, allowing row filtering.

Question 5

In VBA, which method deletes all content and formatting from a range?

Accepted Answer

Range.Clear()

Answer

Range.Clear() removes both the content and the formatting of all cells in the specified range.

Excel VBA Practice Test