Transposing dictionary keys and items into one column

[strud]

I am probably going the long way round but like using the dictionary class.

I can add the keys and items in fine- the keys come from data in column A, while the items from the adjacent cells in column B.

I am trying to transpose the keys and the items into one column so the result is:

Column C
Key
Item
Key
Item

etc etc

My code currently is:

Please Login or Register  to view this content.

This seems to work for the first key and corresponding item but thereafter returns N/A# .

I have also considered:

Please Login or Register  to view this content.

But the result is the same.

Any ideas?

Thanks
Strud

[Norie]

I'm pretty sure you can't do this by transposing.

Try looping through the dictionary and writing the key/item pairs down the column.

Something like this.

Please Login or Register  to view this content.

PS Not sure I've got the order you want, if it's wrong just switch k and dic(k).

[strud]

Brilliant thanks Norie that works perfectly.