Excel VBA: Put dictionary key and item in columns without transposing

Can you tell us why you want to store them this way? If it's just a question of presentation, then you are probably going to be stuck with the column limit. If there are other reasons (not to do with presentation) it might be that you simnply want to report the subset in which you are interested in the horizontal format.

Stating the underlying reason for wanting something is frequently a way to clarify exactly what it is, and why, that you want to do,

Thanks,

Tony

Sorry. I think I was unclear. I would like all the keys to be in one column and all the values in another. The problem that I have is as soon as I try to put my dictionary into a column it has to be transposed to be in a vertical layout. This means that it has to go from having all data in one row to all data in one column. Because of the amount of data I have, I cannot put it in the row to begin with before transposing it into a column.

Just write it to a 2d vertical array before sticking it in sheet

Could you explain how I do this? Here is the code that I am using right now. It counts up the number of times each word occurs in a range and puts it into a dictionary. I am trying to get these to go into a column. I found this code here and modified it a little.

Please Login or Register  to view this content.

Since the output goes into columns (like you want them to be) I don't really get your question.

@bakerman because transpose is slow and has limits on the number of elements

Please Login or Register  to view this content.

Your solution worked great bakerman2. Thanks

You're welcome.

Kyle123 can share the credit because it was his suggestion in Post#4 I put to use.