VBA Output One Column of Array to Worksheet

Hi,

I have a 2D array in VBA (x rows and y columns), and I want to output all of the rows and one of the columns to a worksheet. Any ideas on how I would do that?

I've tried the following, but it hasn't been working - nothing outputs to Excel, and I also don't get any error message:

    With Range(Cells(Rw, Col), Cells(MaxRow + Rw - O_min, Col))
        .Value = WorksheetFunction.Transpose(WorksheetFunction.Index(Arr, 0, 2))
        .NumberFormat = "#,##0"
    End With