Have to transpose twice

[par0016]

I have a vba array that I want to place in a spreadsheet range. This is the only way I could get it to work:

Please Login or Register  to view this content.

When I eliminate the first transpose, it places the first value in all 17 columns.
When I eliminate the second transpose aka Range("A4:A20") = arr, it places the first value in all 17 columns also.
When I eliminate the both transpose functions it doesn't place any values in the range.


My question is WHY? Why do I have to put two transpose functions to get what I want? Is there a better way to do this? I don't understand this at all. I am new to VBA and would think that two transposes would be the same as none. Can somebody please explain this to me. Thanks

[FDibbins]

post deleted...thanks

[par0016]

Sorry about that. Fixed

[Mordred]

This almost seems like this thread that you started and didn't bother to respond to, with two answers given.

[par0016]

I tried all the methods on that thread and nothing worked (half of which had already been tried as stated in the post). I thought reposting would give me the best chance of more people seeing it.

[Mordred]

Nope, you thought wrong. You are violating supposed rules here with crossposting. Plus, you not responding to threads will start to diminish people from helping you. Me for example, since you couldn't bother to let that thread know that "Nothing worked", why would I help.

-Good luck.

[JosephP]

Please Login or Register  to view this content.

[par0016]

For some reason that just doesn't put anything in the range. All the cells are placed in as blank

[JosephP]

then there's nothing in your array (or null strings)

[par0016]

Alright well I guess I have a problem before this then. i will look into it. It's just weird that I can get it to work with the double transpose though. Thanks for the help. I appreciate the time.

[JosephP]

why not post a sample workbook? or a simple test with

Please Login or Register  to view this content.

[Fotis1991]

Is Mordred a Senior member here?

If YES, then we have problem with rule 7 of the forum.

..Don't ignore requests by Administrators, Moderators, or senior members of the forum. If you are unclear about their request or instructions, then send a private message to them asking for help. Do not post a reply in a thread where such a request (e.g., title change, code tags) is pending.

If NO, then we have problem ONLY with rule 5,

Duplicate here.

http://www.excelforum.com/excel-prog...-from-vba.html

[FDibbins]

@ par0016, how is this thread any different from this 1?
http://www.excelforum.com/excel-prog...44#post3194644

If there is a significant difference, please explain how. If not, then this is a duplicate thread, and as such will be closed so that you can continue on the other 1.

I await your answer

[Fotis1991]

@ FDibbins

Which answer?

The OP answer exist in post#5..Read it pls.

..I tried all the methods on that thread and nothing worked (half of which had already been tried as stated in the post). I thought reposting would give me the best chance of more people seeing it.

[FDibbins]

Good point Fotis, thanks, I must have missed that comment, sorry

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.