writing values to range - first entry repeated

[twd000]

I'm having trouble with this set of commands

 'define range to print output column
                Set output_column_range = Sheets(output_response_sheet).Range("rng_DependentData").Columns(x).Cells
                'write data column to range
                output_column_range.Value = output_matrix_column

the range and the array are the same length, 25 elements. However it only writes the first entry to the range, repeating it 25 times, rather than printing all the unique entries. What's wrong with my syntax?

[Leith Ross]

Hello twd000,

I have checked the code range assignments and syntax. There doesn't appear to be problems with this code segment. You do have a lot going on in this workbook. It would help to know exactly what error you are receiving.

Sincrely,
Leith Ross

[Richard Schollar]

Hi

Looks like you have a 1 dimensional array being written to the range so try this:

output_column_range.Value = Application.Transpose(output_matrix_column)

Richard

[twd000]

thanks Richard

transposing the matrix worked perfectly

[VBA Noob]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save