Copying Type String Array to Range in Excel - Invalid Qualifier

Question

I want to transfer the contents from part of the a 'Type' array to an excel range (see example below), but get 'Invalid Qualifier' error. Any help would be appreciated? Public Type typDetails firstName As String lastName As String End Type Dim userDetails(100) As typDetails Public Sub test() userDetails(0).firstName = "Bob" userDetails(0).lastName = "Bobson" userDetails(1).firstName = "Bob" userDetails(1).lastName = "Bobson" userDetails(2).firstName = "Bob" userDetails(2).lastName = "Bobson" Worksheets(1).Range("A1:A3") = userDetails.firstName End Sub Thanks in advance, Alex. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Think you need a loop: Public Sub test() Dim i As Long userDetails(0).firstName = "Bob" userDetails(0).lastName = "Bobson" userDetails(1).firstName = "Bob" userDetails(1).lastName = "Bobson" userDetails(2).firstName = "Bob" userDetails(2).lastName = "Bobson" For i = 0 To 2 Worksheets(1).Cells(1, i + 1).Value = userDetails(i).firstName Next i End Sub