The VBA code ____ refers to the collection of cells in the cell range,A1:B10.
A) Objects(A1:B10)
B) Names(A1:B10)
C) (A1:B10)
D) Range("A1:B10")

Question

Quizplus · Accepted Answer

Range("A1:B10") is the correct VBA syntax to refer to a cell range, in this case A1:B10. Option A is not a valid syntax, Option B refers to named ranges which is not relevant in this case, and Option C is missing the Range object which is necessary to refer to a cell range in VBA.

The VBA Code ____ Refers to the Collection of Cells