Copying an array to a range of cells

[SDruley]

The following code generates error 1004 (application defined or object defined error) on line 17. I am at a loss to figure out why. I want to copy the contents of the array (Taguchi) to a vertical column.

Please Login or Register  to view this content.

Any assistance would be appreciated

[StephenR]

This?

Please Login or Register  to view this content.

[SDruley]

StephenR,

Thank you for your input... still getting the same error.

Stephen Druley

[shg]

Unqualified, Cells is a reference to the active sheet.

Please Login or Register  to view this content.

or,

Please Login or Register  to view this content.

You still need the Transpose as Stephen suggested.

[SDruley]

shg,

Your suggestion is brilliant! Very well done.

Stephen