VBA Transpose a 2D Array

VBA Transpose a 2D Array

Anonymous
Not applicable
1,319 Views
0 Replies
Message 1 of 1

VBA Transpose a 2D Array

Anonymous
Not applicable

I have a routine that reads attributes from several blocks to a 2D Array. My array has about 30 lines x 3000 columns. Afterwards I want to dump this array on an excel sheet but the array has to be transposed before. I want lines and columns to be converted to columns and lines respectively.  This is very easily done on excel using this:

 

example= appplication.transpose(example)

 

unfortunately this isn't working on Autocad VBA. What am I doing wrong? I also tried this:

 

example = Excel1.Application.WorksheetFunction.Transpose(example)

0 Likes
1,320 Views
0 Replies
Replies (0)