You want to dump the values stored in a 12-element array named Rates into the cell range A1:A12. How can you get that done?

Range("A1:A12") = Rates(12)

Range("A1:A12") = Rates

Range("A1:A12") = Rates(1 to 12)

Range("A1:A12") = Application.WorksheetFunction.Transpose(Rates)

Answer:
Range("A1:A12") = Application.WorksheetFunction.Transpose(Rates)

Note: This Question is unanswered, help us to find answer for this one