(Solved) – VBA Matrix Print separate columns


I’ve generated a matrix with x amount of rows and 2 columns. So Matrix(1 to x, 1 to 2)
As my Matrix has two columns, is it possible to print them (Without looping) to two different places.
For example: I want the column 1 of the Matrix to go on Sheet1 column A and column 2 of the Matrix to go to go on Sheet1 column C.

How do i do that? I only know how to print the entire Matrix out and can’t seem to find a way to just print a part of it to a sheet. Below is what i have so far.

Worksheets("Sheet6").Range("C" & ExportToLine).Resize(UBound(Matrix,1), UBound(Matrix,2)).Value = Matrix

Leave a Reply

Your email address will not be published. Required fields are marked *