Message 1 of 1
VBA Transpose a 2D Array

Not applicable
06-08-2018
06:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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)