Copying an array into a spreadsheet

[ihorwitz]

The following code copies "Retail" into the range F1:F11. How can I get it to copy all the data without stepping through each one?

Dim vArray(10)

vArray(0) = "Retail"
vArray(1) = "Food Service"
vArray(2) = "Frozen"
...
...
Range("F1:F11") = vArray

Tks

 

[Norie]

Range("F1:F11") = Application.Transpose(vArray)