how do I transpose data?

[Bronx]

Hello everyone, I having run time error 9 when I tried to transpose data into an array. I want to transpose data from "F3" to "K3" into data1(), during debugging it says that data1() subscript is out of range. Please help me transpose the data. And how does the transpose works?

Please Login or Register  to view this content.

Here is my code:

Please Login or Register  to view this content.

[6StringJazzer]

Here are some issues:

• The array data1 has never been dimensioned so you can't assign anything to it. Also in your assignment you can't use empty parentheses.
• You have declared your variables but you have allowed them all to default to Variant. It is a better practice to declare them as specific data types.
• Your argument to Evaluate is a bit confusing because you are using two nested Transpose functions. That just transposes them once and then transposes them back to where you started.
• If multiple checkboxes are checked then you are copying data into the same array over and over again. If you are requiring that only one of them can be checked, then I recommend using option buttons instead of checkboxes.

You want this. Declaring data1 as a Variant instead of a Variant array allows the dimensions to be set automatically when you do the assignment. After this assignment you can treat data1 as though it had been declared as an array with dimensions (1 To 1, 1 To 6). You don't need any of that Transpose jazz.

Please Login or Register  to view this content.

[Bronx]

Sorry if I misunderstood what you meant.

treat data1 as though it had been declared as an array with dimensions (1 To 1, 1 To 6)

I changed my code as below but there is error runtime 13 type mismatch if I do this.

Please Login or Register  to view this content.

if it is changed to

Please Login or Register  to view this content.

It shows that data1 is empty.

I wanted to use array as there are some blank cells, so I can truncate only the data1 array with data into the body1 variable. Transpose is the only way I know of to store the data into an array.