Case 8-2 Another colleague shares the following code with you: Dim strEmployees(50) As String
' Later in the code
ReDim strEmployees(65).
Which of the following lines could replace the line at the bottom of the code in the sample and retain the data in the elements 0 through 50?
A) ReDim Retain strEmployees(65)
B) ReDim Reserve strEmployees(65)
C) ReDim Restore strEmployees(65)
D) ReDim Preserve strEmployees(65)

Question

Case 8-2 Another colleague shares the following code with you:  Dim strEmployees(50) As String
' Later in the code
ReDim strEmployees(65).
Which of the following lines could replace the line at the bottom of the code in the sample and retain the data in the elements 0 through 50?
A) ReDim Retain strEmployees(65)
B) ReDim Reserve strEmployees(65)
C) ReDim Restore strEmployees(65)
D) ReDim Preserve strEmployees(65)

Quizplus · Accepted Answer

The correct choice is D because using "Preserve" when using "ReDim" will retain the data in the elements already stored in the array while also allowing for additional elements to be added. The other choices are not valid options when using "ReDim".

Case 8-2 Another Colleague Shares the Following Code with You